Hi MRafique Ujjan plz attached your master sheet ,
On 17/01/2010, ayush jain <jainayus...@gmail.com> wrote: > 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 >> >> > -- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~
-- ---------------------------------------------------------------------------------- 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
