Complicated VLOOKUP / SUMPRODUCT formula

[TSparacino]

I can't for the life of me figure out how to make this happen.

Multiple worksheets (time sheets) within this workbook

let me set the stage. Each sheet is a different time sheet for different locations. John smith may work on 3 or 4 of the time sheets on different days. as soon as I put John's name in on say sheet 1, I want his scheudle for all sheets to pop up off to the right and is updated everytime a change is made. Sounds like a vlookup function, but it needs to search over all the sheets. further more when I tested it for just the first page (very basic vlookup) I get a 0 returned... the data range cell that I'm trying to return is not blank either. I use a Sumproduct function on the last page of the workbook to calculate their hours over the entire workbook, but can't figure out how to combine the goal of searching all worksheets with returning what's in the cell and not "calculating" the found values. I can e-mail someone the workbook if need be.

thanks in advance for any help!

 

[VoG]

This may be it (or at least a start) http://www.ozgrid.com/VBA/VlookupAllSheets.htm

 

[TSparacino]

This may be it (or at least a start) http://www.ozgrid.com/VBA/VlookupAllSheets.htm

thanks for the response, but that link doesn't take me anywhere that makes sense. all I see are a few links at the top of the page... the rest of the page is blank... no info regarding VBA.

 

[TSparacino]

never mind... it's working now... I'll review and report back. thanks!