I can auto summarise the Detail Data into the Summary Data using a macro that copies the data elsewhere, pastes it, removes the duplicates, then sorts it and finally puts the Account Codes into the summary space.
But I was wondering if there isn't a simpler way of achieving it.
Any ideas gratefully received.
Here's two ways:
One a simple lookup, but you have to know your account numbers, which you may already know.
The other is a Pivot Table, once the range is highlighted (without the total), select DATA>PivotTable>Next>Next>ExistingSheet (select a cell)>Finish
..then put the Accounts in the left and the Value in the center "data" section.
Last edited by JBeaucaire; 12-16-2008 at 03:18 AM. Reason: Corrected the pivottable range
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for that - much appreciated
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks