hi!

200 files of what *type*?!

-via135


Tom K Wrote:
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 and I can
send you a copy of the files to look at.

Thanks.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=530578