Hello
I've been wracking my small brain on trying to figure this out for my wife. She has one workbook with 7 sheets. the rows of each sheet are the weeks of the year and every two columns is a job, the first of the two being hours the second being hrs times rate of pay. Now each sheet is the same as in the 8th column will all be the same job. I'm trying to figure out how to scan a specific job hours column in every sheet and display results of any row that is not null/zero. This display on another sheet. That way when her boss asks how much labour on job x, she could this formula to figure it out instead of going through each sheet and totalling numbers etc etc.
Any help would be greatly appreciated as my brain is not wrapping around what functions to use and in what order.
Joel
Bookmarks