Re: $$Excel-Macros$$ Macro to sort in different workbook

can u share a sample file on which column you want to apply sorting and all On Wed, Jan 15, 2014 at 10:52 PM, wrote: > I pull data for individual customers from a source system into an Excel > workbook. I have a separate Excel workbook template that contains macros, > which allow me to reformat

Re: $$Excel-Macros$$ Conditional Formatting by Group

you can use this formula to identify duplicates =IF(COUNTIFS($G$1:G2,G2,$H$1:H2,H2)=1,"","Duplicate") On Thu, Jan 16, 2014 at 2:05 AM, JCraig wrote: > Hello Forum. > I use this forum extensively for review and research yet I have never > submitted a question before so hopefully someone may be

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

please share sample file On Fri, Jan 24, 2014 at 2:13 PM, Umesh Kumar wrote: > I would need help in converting table which is in table format to a pivot > format. Below is the sample data which i have: > > >

Re: $$Excel-Macros$$ Required Chart with multiple criteria

see if it helps On Sat, Jan 25, 2014 at 10:25 AM, Rakesh Kumar Sharma < rakeshks@gmail.com> wrote: > Dear Experts, > > Pls consider on chart query. > > > > On Fri, Jan 24, 2014 at 4:59 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Hi Experts, >> >> pl find the attached dat

Re: $$Excel-Macros$$ Extract data from mail attachment.

why you need a macro just for five files On Sat, Jan 25, 2014 at 1:11 AM, Prabhu Pinky wrote: > Hi experts, > I have 5 outlook mails saved in local folder, which has html attachment.. > > How to copy data from those html attachment from each mail in excel sheet. > > Please help with immediate. >

Re: $$Excel-Macros$$ Required Chart with multiple criteria

Dear Experts, Pls consider on chart query. On Fri, Jan 24, 2014 at 4:59 PM, Rakesh Kumar Sharma wrote: > Hi Experts, > > pl find the attached data file. > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa

Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

Hi Rob, To solve the problem of error, you can delete this ( Sheets("List3").Select ), it will not affect the main macro. Basole 2014/1/24 Rob Flott > Anoop, > > When I opened the file I got run time error '57121' > "Application-defined or object-defined error" > And when I clicked Debug it

$$Excel-Macros$$ Extract data from mail attachment.

Hi experts, I have 5 outlook mails saved in local folder, which has html attachment.. How to copy data from those html attachment from each mail in excel sheet. Please help with immediate. -- 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 o

Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

Anoop, When I opened the file I got run time error '57121' "Application-defined or object-defined error" And when I clicked Debug it took me to the Sub Workbook Open() and highlighted the line Sheets.("List").select Any ideas as to why I'd get that error message? Thank you for your help with thi

Re: $$Excel-Macros$$ Help Required

Thanks Ravinder. On Fri, Jan 24, 2014 at 4:37 PM, Ravinder wrote: > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar > *Sent:* Friday, January 24, 2014 4:26 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros

$$Excel-Macros$$ Required Chart with multiple criteria

Hi Experts, pl find the attached data file. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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.facebook.com/discussexcel FORUM RUL

RE: $$Excel-Macros$$ Help Required

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh kumar Sent: Friday, January 24, 2014 4:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Hi Friends, Please find the attachment. Help Please -- Th

$$Excel-Macros$$ Help Required

Hi Friends, Please find the attachment. Help Please -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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.facebook.com/discussexcel FORUM RU

$$Excel-Macros$$ Want to Append a spefic Sheet into one new Sheet in a New workbook

Dear Exparts, I want to append a spefic worksheet from "n" number of work books into one sheet in a new workbook. The date Set is similial in all the worksheets. *Note: Here I dont want to consolidate the data.* *Thanks in advance.* -- Regards, Dileep Kumar Kaza -- Are you =EXP(E:RT) or =N

$$Excel-Macros$$ Need help in converting table format data to pivot format in excel

I would need help in converting table which is in table format to a pivot format. Below is the sample data which i have: