I am trying to copy filtered rows from different spreadsheets and paste them to the same rows in a spreadsheet? I enountered problem as there are merged cells in 2 of the columns and some of the headers of the copied spreadsheets are different from the headers in the paste spreadsheet. Any idea how this can be done?
I attached a similar sample workbook of my problem with original and paste spreadsheets.
Thanks in advance.
Bookmarks