Hello all,
Need help writing a macro that will move data in one specific column and row to another sheet based on the header in row 1.
The columns that need to be moved are:
Library
Deal_Date
Title
At the end of sheet 1 (row 11 in this case), I need to move the data in sheet 2 into sheet 1, keeping the data across each row just as it is in sheet 2.
See sheet 1, then sheet 2, then after macro sheet in attached file:
I'd like to use the headers in row 1 as the unique identifiers for each column. The macro will need to identify the last row of data across all columns in sheet 1, then insert the data from sheet 2 in the corresponding columns, beginning with row 2 in sheet 2. Will need to loop through several thousand rows. Must keep data being moved from sheet 2 to sheet 1 in the same row.
Any help would be most appreciated - thank you!!
Question also posed at Mr. Excel: http://www.mrexcel.com/forum/showthread.php?t=531778
Bookmarks