I’m using Excel 2007. I have a spreadsheet (call it A) with 1800+ rows of accounts and columns to BX, (B) another version of the same spreadsheet with a couple of columns of notes regarding some of the accounts, and (C) a third version I will receive in a couple of weeks with updated info on those accounts in the existing columns, additional columns with new data, and 80 new accounts with their data. Many of the column headings are identical; the primary key to all is the account number.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
What is the best way to pull all this info into one sheet from which I can run pivot tables? Much of the data in the three sheets is identical, but I must capture all the updates in C and the notes in B, without losing any of the historical data in A.
<o> </o>
My Excel skills don’t stretch this far. Have you any suggestions?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>What is the best way to pull all this info into one sheet from which I can run pivot tables? Much of the data in the three sheets is identical, but I must capture all the updates in C and the notes in B, without losing any of the historical data in A.
<o
> </o>My Excel skills don’t stretch this far. Have you any suggestions?
