PDA

View Full Version : [SOLVED] Pivot Table question



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

MUSASHI
10-27-2004, 09:09 AM
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
10-27-2004, 09:14 AM
Hi Mus,

Maybe this will help ...

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

MUSASHI
10-27-2004, 10:20 AM
thanks Firefytr,

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

NOTE TO SELF: Read kb first!!!:whip

works like a charm.!!

thx again

Zack Barresse
10-27-2004, 04:27 PM
You're welcome. Glad it helped. :)

Take care!