T
Tom K
I have about 200 files that have a spreadsheet of active jobs (each job
is saved as it's own name). The spreadsheets list the project manager
and the total # of hours he expects to work on that job. I need to
gather that information into one master sheet. On the source
spreadsheets the project managers are listed in column B and their
respective hours are in column D. On the master spreadsheet I have all
the managers listed in row 1 from left to right (approx 30). In column
A I have all the jobs listed going down. I need to put a formula in
each cell so it will show the corresponding hours for that project
manager and job.
I tried using Vlookup but I get a N/A.
Any help or suggestions would be greatly appreciated.
I'm using Excel 2003 on Windows XP.
If you need clarification please email me (e-mail address removed) and I can
send you a copy of the files to look at.
Thanks.
is saved as it's own name). The spreadsheets list the project manager
and the total # of hours he expects to work on that job. I need to
gather that information into one master sheet. On the source
spreadsheets the project managers are listed in column B and their
respective hours are in column D. On the master spreadsheet I have all
the managers listed in row 1 from left to right (approx 30). In column
A I have all the jobs listed going down. I need to put a formula in
each cell so it will show the corresponding hours for that project
manager and job.
I tried using Vlookup but I get a N/A.
Any help or suggestions would be greatly appreciated.
I'm using Excel 2003 on Windows XP.
If you need clarification please email me (e-mail address removed) and I can
send you a copy of the files to look at.
Thanks.