Hi,
Been running around internet trying to figure this out.. Im a novice in Excel so apologies if its incorrect vernacular being used.
I have a single workbook with multiple sheets. Each sheet contains the same columns, and are all part of the master sheet, broken up for ease of editing into multiple sheets. Several columns have data inputted, and I would like to copy this data from these sheets back into the corresponding row in the master sheet. There is a column in each sheets which shares a unique identifier in a cell also found in the master sheet. Is there a way to copy several columns of data in a row, by matching the unique identifiers between the master sheet each of the other sheets?
Many, many thanks.
Oisin
Bookmarks