MUSASHI
10-26-2004, 08:17 PM
Well I am still spelunking on my weekly timebook...pretty much have the logic....created an intermediate summary of each sheet, out of view for each day of the week....then I set up a pivot table on a seperate page, called Summary...I selected mutiple ranges as an option...and single page field...
I had it summing the names, and their OT and ST hours until I get to Friday....
is there a limit to how many ranges? They are all identical as well....
Pivot malfunctions If I use more than 4 ranges..
any ideas?
Thanks!
Musashi
I had it summing the names, and their OT and ST hours until I get to Friday....
is there a limit to how many ranges? They are all identical as well....
Pivot malfunctions If I use more than 4 ranges..
any ideas?
Thanks!
Musashi