magistercaesar
New Member
- Joined
- Jul 2, 2014
- Messages
- 5
Hey guys! So I need a macro that will allow me to copy values from cells in one book to a table in another book.
I also need the macro to work repeatedly, ie.: It will copy the values to the next blank row in the table.
Basically, I need the following:
The value in K2 of book 1 needs to be copied to column C of book 2.
M3 of book 1 needs to be copied to column E of book 2.
L2 of book 1 needs to be copied to column F of book 2.
M5 of book 1 needs to be copied to column H of book 2.
L5 of book 1 needs to be copied to column I of book 2.
Thank you very much in advance!
I also need the macro to work repeatedly, ie.: It will copy the values to the next blank row in the table.
Basically, I need the following:
The value in K2 of book 1 needs to be copied to column C of book 2.
M3 of book 1 needs to be copied to column E of book 2.
L2 of book 1 needs to be copied to column F of book 2.
M5 of book 1 needs to be copied to column H of book 2.
L5 of book 1 needs to be copied to column I of book 2.
Thank you very much in advance!