Related Posts
True story 😂

Additional Posts in Excel Genius
I truly appreciate this group.

why is index match superior to vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
I’m just here for the character development of you figuring out this on your own lol
Sorry I can’t help! My knowledge of VBA is null. I just subscribed to the post hoping to learn something from the replies 😅
Update: was able to establish the beginning and end values and I am able to return the count of rows between those two parameters. I am either going to assign a value 1-5 or figure out how to do the copy and paste portion.
Update 2: I now have a dynamic range finder based on search functions. I am going to create a loop where it assigns a number at the start of the range and if it hits 5 it will subtract by 4 (to reset the value back to 1).
Let me know if that’s unclear.
-unique row (value searched “paper”)
(Copies and pastes rows into 5 separate columns and will cycle and repeat until new unique row is found) value searched “rock”.
Update 3: was able to assign the data to a fixed number, I just have to write a loop function that places a condition on every time the fixed number hits ‘1’ create a row and push it down.
Can anyone help me, what is the code where I copy and paste based on the value of a different cell (cell value is 1 and then move down one by using offset?)
Hmmmm, how about this i already have my column number by doing an auto fill 1-6, all i have to do is create an artificial row number by saying every time column D is 1, do I+1 in column E, else I? If I can create the row indices then I can just do an index match. Also, how would I have it search the whole column and to skip the empty rows (I made this to be adjustable). I also tried to do a multi statement function but for some reason it isn’t pasting to my other sheet.
Following this thread not because I can help or I have a similar problem. I just want to understand what the heck they are even trying to do.
I basically have most of the code done, I am just stuck on the last part where I need to count the rows. Basically I have a repeating sequence from 1-6, every time the sequence hits “1” in column D, it increases the value of the row in column E by 1 (this is to mark a new row). If I can get this done, I can just Index match and be done with the task.