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

It isn't clear what aspect of this problem you are seeking help with. If
you want a scheduling algorithm, then I think more detailed knowledge on the
problem might be required. If you want to know how to open a csv file,
parse the data and then use the data, then you can start with this:

http://support.microsoft.com/support...eio/fileio.asp
File Access with Visual Basic® for Applications
--
Regards,
Tom Ogilvy

"Alan" wrote in message
...
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