I'm a novice at VBA so I need a bit of help.
I have a worksheet (sheet 1) like this

Col A Col B
Sheet2 ABC
Sheet3 DEF
Sheet3 GHI
Sheet4 JKL

I want to add each row of this spreadsheet to the next blank row of the
worksheet specified in column A.
So if the worksheets are like this

Sheet 2 Sheet 3 Sheet 4
Col A Col A Col A
A C E
B CD

I want to end up like this:

Sheet 2 Sheet 3 Sheet 4
Col A Col A Col A
A C E
B CD JKL
ABC DEF
GHI

Also each time I run the macro the number of rows in Sheet 1 will vary
so I need to loop through sheet 1 until Col A is blank.

Can anyone show me how to do this?
Thanks


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=573666