Hi folks,
I am hoping for some advice on how to best perform a task in Excel, hopefully via a macro.
I assume two spreadsheets in the same book.
Sheet 1
Column A has a unique identifier, approximately 2,000 lines filled out from column A to T
Sheet 2 has the same identifier in column A with about 10,000 lines (some identifiers in sheet 2 don't exist in sheet1), filled out from column A to K.
I am trying to write a macro to insert a new line under each identifier in Sheet 1, merge all cells from A to T and insert the matching data from column K Sheet 2 (ie identifier 1 in sheet 1 will correlate to identifier 2 in sheet 2 and return the value on the same line in column K).
Ideally, this means by sheet 1 will have 4,000 lines in the end with every second line containing data imported from sheet 2.
As I'm writing this I'm thinking I'm dreaming but maybe some clever cogs will have a good idea![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Thanks in advance.
IM
I am hoping for some advice on how to best perform a task in Excel, hopefully via a macro.
I assume two spreadsheets in the same book.
Sheet 1
Column A has a unique identifier, approximately 2,000 lines filled out from column A to T
Sheet 2 has the same identifier in column A with about 10,000 lines (some identifiers in sheet 2 don't exist in sheet1), filled out from column A to K.
I am trying to write a macro to insert a new line under each identifier in Sheet 1, merge all cells from A to T and insert the matching data from column K Sheet 2 (ie identifier 1 in sheet 1 will correlate to identifier 2 in sheet 2 and return the value on the same line in column K).
Ideally, this means by sheet 1 will have 4,000 lines in the end with every second line containing data imported from sheet 2.
As I'm writing this I'm thinking I'm dreaming but maybe some clever cogs will have a good idea
Thanks in advance.
IM