The data in 4 specific cells in C:\Users\Office\Dropbox\WB1 needs to (upon clicking command button) be copied to the next available blank cell in 4 specefic rows in C:\users\Office\Dropbox\WB2.
WB1 Specific Cells List
Sheet1!A4
Sheet1!Q7
Sheet1!N22
Sheet2!E3
Data from these cells are to be copied to the rows listed below respectively.
WB2 Destination Rows (Next available blank row)
Sheet1! Row B
Sheet1! Row D
Sheet1! Row F
Sheet1! Row J
I gather from reading other posts that sending this data within the same WB is fairly easy, is it easy to do between WB's though as i must have seperate WB's? Im a novice with all this so any advice is greatly received.!
Bookmarks