Need a macro to copy data to main file

[alan_ay]

I need to write a macro shift the data from various file to a main file.
For example, shift the data in aa(C2:C21) to the B column of ss which the top cell is B5.

Thank You

[Bob Phillips]

Is ss a different workbook from tha main data? Is it open? if not, is it in a fixed directory?

[alan_ay]

ss a different workbook. ss is in a fixed directory. Thank you.

[Bob Phillips]

Copying the data is simple



With Activesheet

If .Range("A1").Value = "" Then

NextRow = 1
ElseIf .Range("A2").Value = "" Then

NextRow = 2
Else

NextRow = .Range("A1").End(xlDown).Row + 1
End If

'then use NextRow to as the copy to row


If ss is closed you will need to open it.

[alan_ay]

Thanks for your help