Updating data from separate worksheets

Hi there,

I have a main worksheet and each assessor has a copy of this main worksheet but with only four fields to edit for the updates on it. The following fields are updated by the assessors and then I cut/paste into my main sheet with their update.

I = Last visit
J = Last Contact
K = Progress
L = Next plan'd

I would like a way to save this to a folder on the computer and when the assessor update is taken from an email into that directory the main spreadsheet will search through their file and auto populate the new data into the main spreadsheet. Each of the I, J, K and L has a drop down menu on these also with different types of information such as percentages. Can someone please help me work out a way to do this.

The main spreadsheet has another two tabs also, 'Completions' and ELF's - is it possible that when the assessor puts 100% on a candidate that it moves the candidate name from sheet 1 into sheet 2 'Completions' also and same if they put ELF from a certain catagory.

Thanks,
Rob

Rob,

Welcome to the forum. Can you post a copy of your workbook.
This will help in your request.

Hi there,

I have attached two blank templates, the 'main' spreadsheet and the file that each assessor has which needs information pulling from and updated onto the main one.

The information from I - L is needed to be pulled from the Assessor one and go into the main one. Once the Progress field hits 100% is it possible to have that one go into sheet 2 on the main spreadsheet automatically and if it says ELF go into sheet 3 on the main file.

Is it possible to have the assessor files to be downloaded (manually) into a folder on the computer and then the main one automatically updates if there is new data.

Update: Each 'assessor' is on sheet one on the main spreadsheet, is that an issue when pulling multiple data to keep it alphabetically from each assessor being updated into the main spreadsheet as the main one in some of the other fields has information that needs to populate into the Assessor one if possible but I am not sure how to make each 'Assessor' spreadsheet unique so that it only collects data into the Assessor spreadsheet when the main spreadsheet on N and O has the Assessor name. I need it to pull fields E - L and N and O into the Assessor sheet but unique to their name so that means the Assessor sheet has a unique code or something so it only pulls data with their name in it.


Thanks,
Rob

Rob,

Thanks for posting the workbooks. However, in reading what you want to do is a little confusing. (to me that is). Would it be possible for you too update your workbooks with what you expect to see?