$$Excel-Macros$$ to find particular column and insert one column and perform Vlookup using vba

hi experts, Please help me in this concern. i need to perform vlookup function using VBA i have attached sample work book for referance From the attached workbook i need update summary sheet using the company code as base from SBU Mapping sheet. i need to insert one column after Data1 ,

$$Excel-Macros$$ Excel filtered data selection

Hi All, i have excel data in five differrent workbooks which i will consolidate into one workbook and apply filter and select data by category Xin particular column and if yes need to be moved to another sheet and rename as In active.. Please advise themacro or code to be used to select data by

Re: $$Excel-Macros$$ HELP SECOND MAIL

PM, Mahesh parab mahes...@gmail.com wrote: Hi Prathima have done with few steps till pivot table, pls check On Wed, May 4, 2011 at 12:19 AM, Prathima R prathima@gmail.comwrote: Hi Mahesh, Firstly thanks for the reply , i have placed the steps in detail in word document. first open

Re: $$Excel-Macros$$ HELP SECOND MAIL

...@gmail.com wrote: Hi it would be great if u could explain some steps; it seems confusing, keep it as simple as you can; which is the first step, what are the 6 vlookups ? which workbook contain base data of your pivot. On Mon, May 2, 2011 at 10:07 AM, Prathima R prathima@gmail.comwrote

$$Excel-Macros$$ https://docs.google.com/#query/vr?view=0hidden=1visibility=1

i am unable to post in groups i uploaded in groups here is the link please find the below link https://docs.google.com/#query/vr?view=0hidden=1visibility=1 Hi Experts, This report is sent on daily basis please help in this concern if it is automated it could be very much thankful really

$$Excel-Macros$$ NEED HELP

Hi Experts, Due size constance i am sending in two zip folders please check second mail for excel files dump. (This is Second mail please check this one as well -- thanks for cooperation) This report is sent on daily basis please help in this concern if it is automated it could be very much

Re: $$Excel-Macros$$ Fwd: Need Help

\Daniel\mpfe\Prathima R\ 'to be modified Dim inCalculationMode As Integer Application.ScreenUpdating = False inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual Set sh = Sheets(Data) lgRow = [Data!B65536].End(xlUp).Row + 1 Workbooks.Open strPath

$$Excel-Macros$$ Need Advise

Hi experts, I Need your valuable advise and suggesting i am about to appear for the FPA interview very shortly ,can anyone of you suggest me interview questions link if any one you have it. Thanks alot in advance. Regards, Prathima --

Re: $$Excel-Macros$$ Need Help

your needs... Paul -- *From:* Prathima R prathima@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, February 10, 2011 9:11:41 AM *Subject:* Re: $$Excel-Macros$$ Need Help please advice in this concern as i am having around 20-30 workbooks where

$$Excel-Macros$$ Need Help

Hi, i have multiple sheets and i want to count the number of instruments in one go, with COUNTA am not able to get. I tried grouping the sheets but could't get the count of all sheets. need your suggestion Thanks, Prathima --

Re: $$Excel-Macros$$ Need Help

of sheets. For Sht = 1 to sheets.count total = total + application.worksheetfunction.counta(sheets(sht).range(A1:A65000)) next Sht would loop through all sheets and count the number of non-blank cells in column A. ?? Paul -- *From:* Prathima R prathima

Re: $$Excel-Macros$$ Need Help

please advice in this concern as i am having around 20-30 workbooks where in need to count the number of Non-blanks in multilple sheets. Thanks, Prathima On Thu, Feb 10, 2011 at 7:23 PM, Prathima R prathima@gmail.com wrote: Thanks for the response. Here am trying to count the number

$$Excel-Macros$$ NEEDHELP

hi experts, i have one access database where i upload the data from outlook sentmails.all the fields in database are consistent and mail format is also default .but there are around 18-22 fields in the access database template i need to input data from the mail.like these i will be inputting

$$Excel-Macros$$ Fwd: NEEDHELP

hi experts, i have one access database where i upload the data from outlook sentmails.all the fields in database are consistent and mail format is also default .but there are around 18-22 fields in the access database template i need to input data from the mail.like these i will be inputting

Re: $$Excel-Macros$$ Re: Efficiency report

Thanks alot for your...help.. On Sat, Jan 8, 2011 at 11:31 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment On Sat, Jan 8, 2011 at 9:49 PM, Prathima R prathima@gmail.com wrote: Hello, Need your help once again plz. i am in the process of preparation

$$Excel-Macros$$ Need Urgent help

Hi Experts, Please help in this concern, Is there a solution to copy the excel data from web, i need to copy the excel data from website i tried this option from excel 2007 DATA--From web But some error is poping up.. Please advise any macro to reduce this criticality, i need to copy

Re: $$Excel-Macros$$ Fwd: need help

Thanks alot ashish its excellent.. On Sat, Jan 8, 2011 at 3:10 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Please find the attached sheet i