Re: $$Excel-Macros$$ How to create a link to other sheets...

You are welcome Mark!! You can try doing that and let us know if you have any issues. Regards, Praveen On Mon, Jan 18, 2010 at 3:41 AM, Markkim wrote: > Thank you very much Praveen!! > > I would also like to do the same thing from the first sheet.. get > infor from the second sheet and the t

Re: $$Excel-Macros$$ how can I get data customer wise and Salesman wise automatically when I update master sheet1 in their respective sheet.

Hi MRafique Ujjan plz attached your master sheet , On 17/01/2010, ayush jain 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 bes

$$Excel-Macros$$ Help-Format in hierarchy view

Please, help on the attached (details of what I need is listed in the file). In summary, I need to show in tree view the hierarchical relation between employees. I was able to do it with Index/Match but I would like to use VBA for this. Thanks in advance, Cecilia

Re: $$Excel-Macros$$ How to create a link to other sheets...

Thank you very much Praveen!! I would also like to do the same thing from the first sheet.. get infor from the second sheet and the third sheet.. (sorry the idea coming up as I think through).. but I will try it myself.. after studying your code. Thanks again.. Have a nice day!!! On Jan 17,

$$Excel-Macros$$ Help with transposing data for graph

I am trying to create a graph for each store in my data sheet. I have a data sheet with a list of stores that lists the quantity that was ordered by each store for the month of December. Not all stores placed ordered on the same dates. What I would like to do is take the data from store line and c

Re: $$Excel-Macros$$ HELP needed for macro

hi check the file now On Sun, Jan 17, 2010 at 4:27 PM, aju chacko wrote: > HI ashish, >Thanks for reply.But I have some more requirements.The > third worksheet "consolidated" originally doesn't exists,I have created it > for an example.Actually the w.sheet named *SAP *will b

Re: $$Excel-Macros$$ how to use fillcolor for an condition

thanks for the quick reply thanks ankur and harmeet singh On 1/16/10, ankur wrote: > > Hi Ashok > Plz check the attached file > > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Sat, Jan 16, 2010 at 9

$$Excel-Macros$$ Follow us on TWITTER and learn excel

Dear group, If you have not been following us on Twitter for excel tips & tricks, You are missing something. Twitter is great application to share the stuff like this and we are making good use of it. To follow us on twitter, Please join us @ http://twitter.com/exceldailytip If you have any tip

Re: $$Excel-Macros$$ HELP needed for macro

HI ashish, Thanks for reply.But I have some more requirements.The third worksheet "consolidated" originally doesn't exists,I have created it for an example.Actually the w.sheet named *SAP *will be created by downloading data from *ERP.*The w.sheet *physical* will be added to this

Re: $$Excel-Macros$$ How to save Macro custom buttons I created

Hi Makkim, Have you ever used add-in ? You can create your own add-in and link all macros to that add-in. It is a .xla file which is portable easily anywhere. You can list all your macros in your own Menu Bar in excel workbook through a add-in. Every time you reformat your PC or change any setti

Re: $$Excel-Macros$$ how can I get data customer wise and Salesman wise automatically when I update master sheet1 in their respective sheet.

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 wrote: > Dear Excel Experts

$$Excel-Macros$$ how can I get data customer wise and Salesman wise automatically when I update master sheet1 in their respective sheet.

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 CityQuantity Name of Sa