Hi MRafique, You can use pivot tables for all the 6 sheets and which will have source data as master sheet. It would be easier if you could provide the data to our forum to help you.
Thanks and best regards, Ayush Jain On Sun, Jan 17, 2010 at 3:48 PM, MRafique Ujjan <imrafiqu...@gmail.com>wrote: > Dear Excel Experts > > I have a workbook named Sales. In which I have 6 to 7 worksheets > regarding sales. I am giving its detail below > > Sheet1: This is master sheet where I enter all the data or daily data > entry is made here. > > S# Name of Customer Name of City Quantity Name of > Salesman > 1 Sky Communication Karachi 15 mobiles Ahmed > 2 Expert Communication Hyderabad 20 mobiles > Muhammad > 3 Sky Communication Karachi 30 mobiles > Rafique > 4. Expert Communication Hyderabad 15 mobiles > Ahmed > 5. > 6. and so on > In this way I make daily data entry Sheet1. > > • Now what I did to get customer wise data I linked Sheet2 with the > name “Sky Communication” and applied filter for Sky Communication. > • In the same way I linked another worksheet Sheet3 with the name of > “Ahmed” to get sales data for Ahmed. > • Now problem is that every time when I update Sheet1 which is master > sheet I have to manually apply filter each time to get latest data for > each customer and salesman. > • So, is there any way in excel how can I get data customer wise and > Salesman wise automatically when I update master sheet1. > > I have just tried to explain my problem above if it is making some > confusion please ask me for more clarification. > > Thanking you in advance to solve my problem. > > Muhammad Rafique Ujjan > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > >
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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
