$$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 , Data

$$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 wrote: > Hi Prathima > > have done with few steps till pivot table, pls check > > On Wed, May 4, 2011 at 12:19 AM, Prathima R wrote: > >> Hi Mahesh, >> >> Firstly thanks for the reply , i have placed the steps in detail in word >> docu

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

: > 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 wrote: &g

$$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 th

excel-macros@googlegroups.com

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=0&hidden=1&visibility=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

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

rPath As String = "D:\Donnees\Daniel\mpfe\Prathima R\" 'to be > modified > > Dim inCalculationMode As Integer > > Application.ScreenUpdating = False > > inCalculationMode = Application.Calculation > > Application.Calculation = xlCalculationManual > > Se

$$Excel-Macros$$ Need Advise

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

$$Excel-Macros$$ Need Help

My colleague has this equation set up to count the number of cells within a range that are three standard deviations higher than the mean. But when he has N/As in the set, it's returning those in the count as well. Do you have any ideas on how to adjust the formula to only count straight numeric v

Re: $$Excel-Macros$$ Need Help

. > Then, in the "report" file, > list the file name of each file, the number of sheets and the number of > records. > I can give that to you and then you can customize it to fit your needs... > > Paul > > -- > *From:* Prathima R

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 wrote: > > Thanks for the response. > > Here am trying to count the number of n

Re: $$Excel-Macros$$ Need Help

heets. > > 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". > > ?? >

$$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 -- -

$$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 aroun

$$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 aroun

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

Hi , I tried this macro but I am unable find the pdf files and when I click on file name button however if I still proceed by giving the path where pdf Is located macro is running fine But it is not saving the word doc . error message is popped up stating already in use thought I closed and use

$$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 literall

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

Thanks alot for your...help.. On Sat, Jan 8, 2011 at 11:31 PM, ashish koul wrote: > > check the attachment > > > > > > On Sat, Jan 8, 2011 at 9:49 PM, Prathima R wrote: > >> Hello, >> >> >> Need your help once again plz. >> >&g

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

Thanks alot ashish its excellent.. On Sat, Jan 8, 2011 at 3:10 PM, ashish koul 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 could able to b