Hello, I hope someone can help me.
I have a master spreadsheet that has details of a number of people. It includes their names, start and end dates, rates etc.
I am being given 3 other spreadsheets each month from different sources. Each spreadsheet will contain a similar thing but not necessarily in the same columns.
I need to put all 3 of these new spreadsheets into the master sheet but following a certain set of rules.
1. If all the data for a row matches a row in the master then do not copy it across.
2. If the same person is in the master spreadsheet as on one of the other 3 but some of the details are different then update the master sheet fields that are different.
3. If a row in any of the 3 spreadsheets does not exist in the master then add it into the master.
4. The final thing is to only look at rows in the 3 spreadsheets if they have one field showing as 'New'.
What I am trying to do here is automate a task that is currently being done manually and taking someone many hours to do.
I hope this makes sense. Maybe Excel is not really the tool I should use for this and if so any guidance on what I should use (Access for example) would be very much appreciated.
Thanks
Lee
I have a master spreadsheet that has details of a number of people. It includes their names, start and end dates, rates etc.
I am being given 3 other spreadsheets each month from different sources. Each spreadsheet will contain a similar thing but not necessarily in the same columns.
I need to put all 3 of these new spreadsheets into the master sheet but following a certain set of rules.
1. If all the data for a row matches a row in the master then do not copy it across.
2. If the same person is in the master spreadsheet as on one of the other 3 but some of the details are different then update the master sheet fields that are different.
3. If a row in any of the 3 spreadsheets does not exist in the master then add it into the master.
4. The final thing is to only look at rows in the 3 spreadsheets if they have one field showing as 'New'.
What I am trying to do here is automate a task that is currently being done manually and taking someone many hours to do.
I hope this makes sense. Maybe Excel is not really the tool I should use for this and if so any guidance on what I should use (Access for example) would be very much appreciated.
Thanks
Lee
