$$Excel-Macros$$ Latest date required for latest change in 2 different categories

Hello All, I need help on getting Latest date required for latest change in 2 different categories In below data for supplier 190007, I should get Aug'11 for C category & Oct'14 for M category which is showing latest updates in resp category. Pl support Supplier Number C M Grand Tota

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

Can you pl tel me how to run it, as I cant see option available in view-> Macro On Saturday, February 25, 2012 6:31:12 PM UTC+5:30, ashish wrote: > > Hi Group > > Try this udf it will help you in finding the time and distance between two > cities using Google Map > > > > -- > *Regards* > * * >

$$Excel-Macros$$ Macro for filter data & send it to respective user through mail

Hello, I am looking for Macro for filter data & send it to respective user through mail, pl find details below 1) I have various dept like SCM / Mktg / Engg / HR etc & data attached to each dept, when we apply filter we can see data related to particular dept. 2) I want to create separate excel

Re: $$Excel-Macros$$ How to develop a query for excel table

@ Tariq & XLS S.. I will also required all details in next line for input given by me.. E.g If for supplier no. 'X' & Buiness Role 'Y'..if ther are 3-4 contacts details available then I should get all 3-4 contact details against input given by me..it should fetch all details related to input n no

Re: $$Excel-Macros$$ Copy & paste data for dynamic data_need Excel Macro Solution

How to upload a excel file??..kindly help On May 13, 7:29 pm, ashish koul wrote: > can you attach the sample sheet > > > > > > On Thu, May 12, 2011 at 3:47 PM, sagaraher wrote: > > I have got following data in excel. I need to copy 1st number in given > > row

$$Excel-Macros$$ Copy & paste data for dynamic data_need Excel Macro Solution

I have got following data in excel. I need to copy 1st number in given row for e.g. 122532 should be copied against 100 for 4 times & similar way 321654 should be get copied against 200 for 3 time like way. ( Problem is that I'm not sure how many times 100 or 200 nos. comes ) kindly suggest me mac

$$Excel-Macros$$ Graph as per parato,,, ascending order

Hi frds.. I need help for plotting graph.. I ve a data for quality issuesi ve 10 diff. clients & ther freuency...I need to plot graph in ascending order by default in every month. e.g. Sr. No. ClientFrq. 1X 10 2Y

$$Excel-Macros$$ Automatic goal seek...

Hi frds. plz anyone tell me, is ther ny way to us goal seek automatic calculation... I'v data in which I do always chng variables..n thn i apply goal seek.. but i want automatic goal seek operation shld apply as soon as i chng variable data.. thnx in advance.. -- -

$$Excel-Macros$$ need ur help..

hello frds... I'm making 1 system where i ve to enter 35 entry as input..which is compared to targets set by r company... b'coz of tht we can calculate various matrix..but this is specific for 1 month.. Is ther ny method, so tht i can save previous month data..n i can enter new value for new mont