I am trying to figure out a code to copy and paste items to the next empty row on the summary page.
Basically, what I want the code to do is:
Select.Sheet2 Copy A2:end of RowA items and paste it on Summary first empty spot (A2)
Select.Sheet3 Copy A2:end of RowA Paste on next empty Spot on Summary Page in Row "A"
Select.Sheet4 Copy A2:end of RowA Paste on next empty spot on Summary Page in Row "A"
This is obviously just an example workbook the sheets that I deal with are hundreds if not a couple thousand-line items.
Not all the Rows have the same number of items on them so I cannot just post paste specific cells.
Thank you for your time!
Bookmarks