Dear Michael, Thanks for the piece of advice. I'm basically new to the management accounting world. Please do not take this as if I am new to finance and accounting (But my excel skills are resticted and have no knowledge of access yet). That said, can you guide me to some tutorials etc or books from where I can jump start into this huge ocean.
Kindest Regards. Chaudhry On Tue, Apr 13, 2010 at 11:58 AM, MD18358 <michael.e.dray...@citi.com>wrote: > > Hi Chaudhry, > I hate to commit sacrilege in the Excel VBA sight but its sounds like > excel is probably not the right solution for such a massive task. > Access can handle larger database queries. Even if you use Access to > perform all your summerizing and then export it back to excel for the > presentation parts, I think you you come out with far less stress. > > -Good Luck > Michael > > > > On Apr 12, 2:41 pm, Chaudhry Zahid Ali <chaudhry.zahid....@gmail.com> > wrote: > > Hello Group, > > > > *Overview:* > > I have a issue to discuss. I have got an excel sheet which contains over > > 150,000 trial balance account subheads made up of data from different > > branches (All Branches). So there are multiple account heads that are > > repeating. I have constructed a Pivot table out of the data which on > > application of a filter gives me NP and Sales amount for different types > > (Huge, Big, Medium, Small) of branches. > > > > *Required:* > > Now what I want to do is to apply two different filters on two different > > columns which fall under the same Pivot table. Is it possible, or am I > > asking too much from excel. I know I can construct a seperate table for > both > > NP and sales, but the issue is I am trying to automate the process and if > I > > make seperate account heads for seperate files, well, I will be ending up > > making atleast 50 Pivot tables in a file which has already crossed 200 > MB. > > > > *In Short:* > > *HELP* > > ** > > Thanks...... > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > To unsubscribe, reply using "remove me" as the subject. > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
