hi arnsto ,
Well well well! Hope you're familiar with vba ...
I've got this issue and I've solved it this way enjoy it :
Public Function Report0() As Integer
Report0 = 1
On Error GoTo errorhandler
Dim db As String
Dim sql As String
Dim pt as PivotTable
db = "The database full p
This will help you!
Enjoy it!
You didn't supply info about session
Sub Unpivot()
Dim row As Long
Dim col As Long
'Where to put the unpivoted array
' Should be in another sheet but you've put it on the same ..?!.
Dim row_dest As Long
row_dest = 10
'To simplify the algo
Dim PROGRAM, ROLLNO, C
Hello again!
This VBA code create 4 pivot table based on the same data cache;
This is exactly what you have asked !
>Want:
>a) vba routine to ensure that all pivots are based on the same pivot
>cache
>b) select one "mother pivot" cashe to be used by all pivots table
Regards
--
There is no explanation in your worksheet!
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.
Hello,
I think i did some effort to solve your problem take a look at this
post :
http://groups.google.com/group/excel-macros/browse_thread/thread/29083fc9f3da2cdc
Hope this helps you
--
--
Some important links for
Dear Excel User,
You have submitted this issue in several post. It's not a good
practice
Some users have already responded to your request.
I think that you should maintain one post for your issue so you can
capitalize the suggested solutions.
Best regards
On 14 nov, 09:33, Jitender wrot