Pivot Table question

[MUSASHI]

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

[MUSASHI]

duh, ranges werent lined up...hehe sorry!


how can I get it (pivot table)to auto update without having to manually refresh?

appreciate it

Mus

[Zack Barresse]

Hi Mus,

Maybe this will help ...

http://www.vbaexpress.com/kb/getarticle.php?kb_id=80

[MUSASHI]

thanks Firefytr,

yeah I was trolling that a minute ago. You guys keep pointing me back there...

NOTE TO SELF: Read kb first!!!

works like a charm.!!

thx again

[Zack Barresse]

You're welcome. Glad it helped.

Take care!