S
Special-K
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
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