Hi all! Me again!
Right now, the function of the code is to go to a selected worksheet, copy data, and paste it in the main worksheet. It only works for one sheet at a time. I would like to manipulate the code so that when multiple sheets are selected, it will copy/paste data into the NEXT OPEN ROW (one data set after another).
Currently, the first data set will go to the main page but the second will just then paste directly on top of the first.
So here is the code I would like to manipulate: I have tried adding .Offset(1,0), .End(xlUp), etc. but I don't think I am adding it in the correct place. I know that changing the red 2 in the following is what changes where the data is pasted (2nd row in table).
And this is the rest of the code for reference:
I have attempted to add a variable that finds the next open row in the table and replace the red 2 (in the code) with said variable, but I can't figure out how to correctly write that. This is the code that I found that I tried to edit/add in but then the data just started pasting into the 5th or so row and did not pull all data in correctly.
Update if anyone was interested, we figured it out!
Bookmarks