Working across Multiple Spread sheets

**menor59** · 09-30-2008, 02:56 PM

Hello all..

At my office we use excel to clock time on a weekly basis. every week we open a work book and in that work book are worksheets that have job Numbers in them. We then put our time in and etc. etc. so basically a Workbook will contain 52 worksheets with Job Numbers and hours associated with it. Each Work sheet is named by the First Sunday of the month.. in the following format..mmm dd, yyyy. What id like to do is have a work sheet where you would type in the job Number and tab or hit a button that will Look at all 52 worksheets and return hours based on that Job Number Make sence?? FYI a New Work book is generated every year so JAN 06, 2008 next year will end up being JAN 04, 2009 is it also possible to dynamically get that? last thing I need to be able to total those hours based on that job Number as a Summary for the year. I have included jpgs to kinda help with what im trying to do...Thanx. ** As a side note on the Query Work sheet I am Using the following formula in P3 which works fine =LOOKUP(Query!H$2,'Jan 06, 2008'!B$5:B$15,'Jan 06, 2008'!V$5:V$15) as you can see by the jpg image...but i want the formula to actually use the information thats in B3-B54 because it will change next year..

**royUK** · 10-01-2008, 02:27 AM

It would be to have all the data on one sheet in a proper table format then you can use a PivotTable

**menor59** · 10-01-2008, 10:39 AM

The Indirect is pulling information from another worksheet properly, but in the picture im providing its referencing a cell thats referencing that work sheet. It is pulling the proper number but i need it to add up multiple cells on that sheet...see attachment and thank you for the responce.