Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method

Re: $$Excel-Macros$$ Macro Problem...plzzz help

Hi PFA, You have to ensure criteria range is in same sheet in which you apply filter. you also need to extend your range to accommodate rest of data.. Thaks On Fri, Jul 5, 2013 at 5:25 PM, SG wrote: > hi Experts, > > I'm in a great problem as i'm beginner in macros.I have created a templat

Re: $$Excel-Macros$$ Formula require

Use the Function and PivotTable =IF($B6<>"";SUMPRODUCT(($C$6:$C$14=H$6)*($B$6:$B$14=$G7)*($D$6:$D$14));"") Attachment. 2013/7/6 Anil Kumar > > -- > *From:* Prabhakar S H > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, 4 June 2013 4:49 PM > *Subject:* $$E

Re: $$Excel-Macros$$ Formula require

From: Prabhakar S H To: excel-macros@googlegroups.com Sent: Tuesday, 4 June 2013 4:49 PM Subject: $$Excel-Macros$$ Formula require Hi Team,   i want to get formula to find Total value of cars with black color only. pls help.   Rgds, Prabhakar -- Are you

$$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down lis

Re: $$Excel-Macros$$ i want fix the given value in the rows

is working days linked with any sheet. what will be the source for working days On Fri, Jul 5, 2013 at 5:32 PM, jmothilal wrote: > > Dear Any one, > > >i want fix the given value in the rows ( i am changing > working days based on month) > > file attached > -- > > *J.Mothil

$$Excel-Macros$$ help: can we automate chrome just like we do for internet explorer

Hi All, Can you please help me out in automating chrome from vba excel just like we do through internet explorer. i need to extract data and also print the webpage. i am able to do it through internet explorer. Can we do the same through chrome as i need it as the website supports chrome better th

$$Excel-Macros$$ Re: Macro Problem...plzzz help

plz experts..spare some time on my problem. looking forward for your help. On Friday, July 5, 2013 5:25:27 PM UTC+5:30, SG wrote: > hi Experts, > > I'm in a great problem as i'm beginner in macros.I have created a template > in which the data would be extracted on basis on 3 criterias.However,

Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

Thanks everyone for your valuable reply. I will try with it to get the good result. Thanks again. Regards Pravin Gunjal. De Premor d...@premor.net via googlegroups.com 7:11 AM (11 hours ago) to excel-macros To ke

$$Excel-Macros$$ group dates into months

Does anyone know how to group dates into months in a Pivot table in Excel 2003? Regards, Krishnaraddi V Madolli. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward,

$$Excel-Macros$$ Macro Problem...plzzz help

hi Experts, I'm in a great problem as i'm beginner in macros.I have created a template in which the data would be extracted on basis on 3 criterias.However, by using macro, i'm unable to extract it.For criterias, i have created drop-down list by using Data validation & name manager. Now firs

Re: $$Excel-Macros$$ Not getting daily emails

Check ur google group settings Sent on my BlackBerry® from Vodafone -Original Message- From: PrIyAnKa Sender: excel-macros@googlegroups.com Date: Fri, 5 Jul 2013 14:27:14 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Not getting daily emails Dear Team Kindly d

$$Excel-Macros$$ Not getting daily emails

Dear Team Kindly do the needful, i have subscribed to the group and i am still member of it but not getting daily mails Regards Priyanka -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.f

Re: $$Excel-Macros$$ Need Formula

Hi Prabhakar find the solution as per your requirement On Fri, Jul 5, 2013 at 12:32 PM, Prafull Jadhav wrote: > Dear Prabhakar, > > find the same ...It is alternate use... > Our expert can give you better solution on it. > > Regards, > Prafull Jadhav. > MIS-executive. > > > > On Fri, Jul 5, 2013

Re: $$Excel-Macros$$ Need Formula

Dear Prabhakar, find the same ...It is alternate use... Our expert can give you better solution on it. Regards, Prafull Jadhav. MIS-executive. On Fri, Jul 5, 2013 at 11:27 AM, Prabhakar S H wrote: > Hi Team, > > I need your help to get details with formula in attached file. > > Rgds, > Prabha