Hi,
Very limited excel knowledge so please bear with me!
I take a data dump on a Thursday to sheet_1, this data is 4 columns (A-D ie activity ID, description, resource, lead craft) by approx 200 rows. There is additional columns (E-J) for each row that are then populated by employees with the relevant data to complete the work.
I then take a data dump on a Tuesday to sheet_2 and the data may change, however I want to transfer over the relevant employee populated data. Column A contains a unique 'activity ID'.
Is there a formula I can create to look for the unique 'activity id' then copy columns 'E-J' from sheet_1 to sheet_2?
On the attached snip, the light blue is the locked data dump, while the dark blue is the user entered data that i would like copied over.
I hope that makes sense and thank you for any help!
Very limited excel knowledge so please bear with me!
I take a data dump on a Thursday to sheet_1, this data is 4 columns (A-D ie activity ID, description, resource, lead craft) by approx 200 rows. There is additional columns (E-J) for each row that are then populated by employees with the relevant data to complete the work.
I then take a data dump on a Tuesday to sheet_2 and the data may change, however I want to transfer over the relevant employee populated data. Column A contains a unique 'activity ID'.
Is there a formula I can create to look for the unique 'activity id' then copy columns 'E-J' from sheet_1 to sheet_2?
On the attached snip, the light blue is the locked data dump, while the dark blue is the user entered data that i would like copied over.
I hope that makes sense and thank you for any help!
