Greetings all,
A small problem has stumped me !
I have a pivot table result :
A B D F H
1 2 3 4 5
These have to go into a table with
A B C D E F G H
hos do I make VB say .....if active cell =A then move to the next column. else inset a new column and call it A. then make it do the same calculation for the next column.. B then C, D E ect..
This will then give me a a mock up table of the main table.
any ideas.. thanks
A small problem has stumped me !
I have a pivot table result :
A B D F H
1 2 3 4 5
These have to go into a table with
A B C D E F G H
hos do I make VB say .....if active cell =A then move to the next column. else inset a new column and call it A. then make it do the same calculation for the next column.. B then C, D E ect..
This will then give me a a mock up table of the main table.
any ideas.. thanks