Hi there,
I'm going to be having a csv file from a database on a daily basis to allocated workload to my team. I have made a spreadsheet which uses VLOOKUPs to asign work to people, based on who completed the task originally. Ideally I'd like to have some macro or something where I can tell it to look directly at the csv file and allocated the work. ie if the task is completed by person a, it can not be checked by them and has to be checked by person b through to h. Please help as at the moment with my VLOOKUPs I need to break into the csv file and then take the work done by individuals and run through the VLOOKUP formula but can't do this for everyone in the team at the same time.

Any ideas would be fantastic.
Many thanks