Daily Timesheet data collection

[Grimzby]

Hello and happy new year to all....i had created an excel workbook for timesheets but became so big that it would take for ever to autosave because of terrible setup of the file.....i am a novice with excel and would like to make a workbook that i can fill out daily timesheets and save the data to a master sheet...the criteria's are contract ticket # in red and contract # in orange and the data i want to collect under these criteria are the hrs in yellow,green,blue.

[Gearcutter]

Hi

A Happy New year to you.

I have used asimple Hlookup Function to bring up the values you wanted on sheet2 see the attachment

Regards Howard

[jonbolton]

I have used asimple Hlookup Function to bring up the values you wanted on sheet2 see the attachment

Gearcutter - does that work in Excel2003 as well... and if so, are you able to post a converted file??

[oldchippy]

jonbolton here's a copy of Gearcutter's file in 2003 version

[jonbolton]

Excellent, many thanks oldchippy.