Hi - I have a pivot table that contains income statement information. Since pivot tables will not allow for insert of a row with a a formula I want to pull data from the pivot table into a new worksheet to obtain the format I need. Below is format of my pivot table. I have tried to use the get pivot data formula, but if the data changes from month to month (ex. new accounts added or deleted) I can not get the format to remain consistent. I have tried to use a lookup formula based on account name, but sometimes accounts have the same name for different accounts, so it pulls in the first line of information that matches.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
If anyone has any ideas or can point me in the right direction that would be great!
<o> </o>
Thank you
<o> </o>
<o> </o>
Account Account Name Company 1 Company 2 Company 3
1010-00 Checking - Acct1 100
Checking - Acct2 150
Checking - Acct3 200
1010-01 Checking - Acct1 200
Checking - Acct2 250
Checking - Acct3 300
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>If anyone has any ideas or can point me in the right direction that would be great!
<o
> </o>Thank you
<o
> </o><o
> </o>Account Account Name Company 1 Company 2 Company 3
1010-00 Checking - Acct1 100
Checking - Acct2 150
Checking - Acct3 200
1010-01 Checking - Acct1 200
Checking - Acct2 250
Checking - Acct3 300
