I want to write a macro for some data in excel. I have multiple worksheets that I need to copy a column of data from each and paste them into rows in another "compiled" workbook. I have gotten the point where I am copying the data from each but am pasting them into the same row as the prior. I need a loop that pasted the next worksheet's data into the next row. Can you help me?
Here's my code...
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
Application.CutCopyMode = False
Range("A3").Select 'first row of data begins at 3rd row of 2nd column, want a loop that adds to row below'
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _