$$Excel-Macros$$ Re: how to fill series

Hi amir shahzad Plz find attached is solution. Regards Mukesh On Wed, Jul 29, 2009 at 12:58 AM, Aamir Shahzad aamir...@gmail.com wrote: Dear Members, I have little issue Series please see attached sheet I just want to know how I put series if I have thousand of names. But space is problem.

Re: $$Excel-Macros$$ Query

://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Mukesh Kumar Jha Opera

$$Excel-Macros$$ Query continuous copy paste

that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Query continuous copy paste

according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1

Re: $$Excel-Macros$$ Query continuous copy paste

columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mukesh, Please see attached sheet... I hope

Re: $$Excel-Macros$$ Query continuous copy paste

Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote: Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long

Re: $$Excel-Macros$$ Query continuous copy paste

of Header names or count ? Else i feels i am unable to make clear my query to you ! Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 11:18 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mukesh, See attached sheet Only procedure name is incorrect during calling under Command

Re: $$Excel-Macros$$ Query continuous copy paste

Thanks very very much Sam Mathai Chacko sir. This was the resultant code i was looking for. You are marvellous in excel sir. Thanks again. Regards, Mukesh Kumar On Wed, Feb 1, 2012 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote: The code I gave was exactly for assigning any number

$$Excel-Macros$$ Need formula for rearranging all column data to single column

Hi Experts, I need formula (not macro code) to rearrange various column data in a single column. Sample file is attached herewith. Regards, Mukesh Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

$$Excel-Macros$$ Need macro or Formula

Hi Experts, I need macro /formula for query given in attached file. The result should come based on values given in column A. Regards, Mukesh Kumar -- 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

Re: $$Excel-Macros$$ Need macro or Formula

Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is coming twice in result. Can it also come single time. Regards, Mukesh Kumar On Tue, Jul 16, 2013 at 1:48 PM, De Premor d...@premor.net wrote: Solution Attached On 16/07/2013 14:10, Mukesh Kumar wrote: Hi Experts

Re: $$Excel-Macros$$ Need macro or Formula

Thanks DP Sir, the code is now working perfectly. Regards, Mukesh Kumar On Wed, Jul 17, 2013 at 6:40 AM, De Premor d...@premor.net wrote: ignore my last email, i've made some change in variable declaration PFA On 17/07/2013 7:32, De Premor wrote: Hi, Mukesh Try to change this code

$$Excel-Macros$$ paste special particular formula

Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ paste special particular formula

= lngCount + 1 End If End If Next lngC Next lngR ActiveSheet.UsedRange.Value = VarArr MsgBox strFormula is replace in lngCount Cells, vbInformation End Sub On Thu, Sep 26, 2013 at 3:40 AM, Mukesh Kumar mukeshka...@gmail.comwrote: Hi

Re: $$Excel-Macros$$ paste special particular formula

Rajan ji , this macro code is limited to one sheet only. I want the macro that works upon all sheets at once. Regards, Mukesh Kumar On Thu, Sep 26, 2013 at 3:39 PM, rajan verma rajanverma1...@gmail.comwrote: HI Mukesh i have seen this query many time on this group and another forums, please

Re: $$Excel-Macros$$ paste special particular formula

Thanks a lot Rajan Ji for your help. This code is working fine. Regards, Mukesh Kumar On Fri, Sep 27, 2013 at 12:03 PM, rajan verma rajanverma1...@gmail.comwrote: So problem was the reference in formulas , if any formula have reference like A1:A5 and when it will get evaluate by VBA (i am

Re: $$Excel-Macros$$ paste special particular formula

Rajesh Ji, In my workbook, formulas are in range b. This macro code is working on other ranges also. Thanks to you very much. Regards, Mukesh Kumar On Fri, Sep 27, 2013 at 1:17 PM, Ravinder ravinderexcelgr...@gmail.comwrote: But where u want to paste those formula means which range all

$$Excel-Macros$$ Macro code requirement

to dropdown list. Please provide macro code for this. Sample file is attached. Please note that dropdown list in this sample file is in A7 cell. I want macro code that works on dropdown list regardless of dropdown list position i.e it may be in any other cell in my other files. Regards, Mukesh Kumar

Re: $$Excel-Macros$$ Macro code requirement

Dear Sir, Please check that there is no changes done in your attached file. Regards, Mukesh Kumar On Wed, Oct 9, 2013 at 4:46 PM, Ravinder ravinderexcelgr...@gmail.comwrote: pfa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh

Re: $$Excel-Macros$$ Macro code requirement

have taken only 31 character if text is more than 31 character. ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Wednesday, October 09, 2013 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel

$$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values

Hello Experts Please provide me solution for the query given in attached file. Thanks Regards, Mukesh Kumar -- 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

Re: $$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values

actual requirement is that formula recalculate within formula by values formula can we anywhere in the sheet. Regards, Mukesh Kumar On Sat, Jan 11, 2014 at 10:51 PM, ashish koul koul.ash...@gmail.com wrote: try this Sub test() Range(d2:d8).Value = Range(d2:d8).Value End Sub On Sat, Jan

$$Excel-Macros$$ Replace formulas with values

formulas too it would be better that on running macro, user form appears that asks for the range where to run this macro. Please provide help. Regards, Mukesh Kumar -- 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

Re: $$Excel-Macros$$ Replace formulas with values

koul.ash...@gmail.com wrote: Sub test() Dim i As Long For i = 2 To Range(a65356).End(xlUp).Row Range(c i).ClearContents Range(c i).Formula = = Range(a i).Value * Range(b i).Value Next End Sub On Sat, Jan 18, 2014 at 12:24 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Hi

Re: $$Excel-Macros$$ Replace formulas with values

some solution, but I didn't understand how to apply these codes. Please help me out in this matter. Link is http://www.vbaexpress.com/forum/showthread.php?19661-Showing-Formula-with-valueshighlight=precedent Regards, Mukesh Kumar On Sat, Jan 18, 2014 at 3:43 PM, Ravi Kumar excellearn2

Re: $$Excel-Macros$$ Replace formulas with values

Great Ravi bro. This is exactly what I wanted. Thanks for your help. Regards, Mukesh Kumar On Mon, Jan 20, 2014 at 11:26 AM, Ravi Kumar excellearn2...@gmail.comwrote: PFA…, I guess you are looking for this. J *Warm Regards,* *Ravi Kumar.* *From:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

Please add my number 9650590467 On 8 Aug 2016 9:43 pm, "Rajeev Ranjan" <06raj...@gmail.com> wrote: > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you >> wants to

$$Excel-Macros$$ Job- Required Excel Expert

Hi Excel Experts, We need some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type: IT-Consulting Company

$$Excel-Macros$$ Job- Required Excel Expert

Hi Excel Experts, We need urgent some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type:

Re: $$Excel-Macros$$ Job- Required Excel Expert

Hi Anil, Please find below my emailid mukeshconsci...@gmail.com Thanks Mukesh - Original Message - From: anil kumar To: excel-macros@googlegroups.com Sent: Saturday, October 22, 2011 12:28 PM Subject: Re: $$Excel-Macros$$ Job- Required Excel Expert Hi Mukesh, Plz

$$Excel-Macros$$ Job- Required Excel Expert

Hi Excel Experts, We need some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type:

Re: $$Excel-Macros$$ Help needed..?

Hi Sriram, Please find attached solved sheet. Thanks Mukesh - Original Message - From: sriram ji To: excel-macros@googlegroups.com Sent: Monday, October 24, 2011 7:04 PM Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find the attached file, and provide

Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year

Hi lee, Please find attached formula for your query. Thanks Mukesh - Original Message - From: Sara Lee To: excel-macros@googlegroups.com Sent: Monday, October 31, 2011 6:49 AM Subject: $$Excel-Macros$$ formulas to get the week in the month and week of the year hi i

$$Excel-Macros$$ Job- Required Excel Expert

Hi Excel Experts, We need some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type:

Re: $$Excel-Macros$$ remove a certain text from every sentence

Hi Smitha, Try below formula =RIGHT(A1,LEN(A1)-FIND(:,A1)) Thanks Mukesh - Original Message - From: smitha.kumari To: excel-macros@googlegroups.com Sent: Thursday, November 10, 2011 11:32 AM Subject: RE: $$Excel-Macros$$ remove a certain text from every sentence The