$$Excel-Macros$$ Required fastest vlookup formula

Hi Friends, We have more than 3 lacks data in our excel,so put the vlookup formula it will take huge time. Please help as the fastest vlookup formula or VBA *Regards* Karthik.N Virus-f

$$Excel-Macros$$ Re: VBA to merge / unmerge identified rows when target is used

http://chandoo.org/forum/threads/vba-to-merge-unmerge-identified-rows-when-target-is-used.33523/#post-199415 Thanks On Thursday, 9 March 2017 11:59:42 UTC+5:30, Maatangi M. Karthik wrote: > > Hi, > > In the attached excel I would want to be able to merge two rows for > certain continuou

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Thursday, March 2, 2017 12:33 PM,

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

xt Targ > > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you c

$$Excel-Macros$$ Exel macro help

latest should be updated. Looking forward to hearing from all of you Cheers Karthik -- 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 RULES 1) Use concise

$$Excel-Macros$$ Macro to pull data from multiple files in a folder and also copy only certain columns to destination

Hi All, I am working on a macro to pick various columns from files stored in a folder. There are various column headers under each file. Macro should pick all and copy to a temporary sheet and then based on mapping to copy only those columns that are required. Also, column headers could be nam

Re: $$Excel-Macros$$ How to use VLOOKUP formula using Array code.

gt; > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesl

$$Excel-Macros$$ How to use VLOOKUP formula using Array code.

Dear All, I need to reconcile the two sheets having more than 1,50,000 rows. I used following VBA code. however it is taking more than 30 minutes to give output. Sometime it gets stuck when macro running. Sub MakeFormulas() Dim SourceLastRow As Long Dim OutputLastRow As Long Dim sourceSheet As

Re: $$Excel-Macros$$ Applying formulas in large number of rows using VBA

p the code, you can set Application.screenupdating to false and > probably not use a loop and consider some other options, > > Would you mind posting your current code, so we can take it from there > > On Tue, Apr 26, 2016 at 11:17 AM, karthik kumar > wrote: > >> Hi All,

$$Excel-Macros$$ Applying formulas in large number of rows using VBA

Hi All, I need to keep formula as Vlookup in approximately 50,000 rows using VBA code. I have tried with many code. However, it resulted the excel to slow and take so much time to give output. Please suggest me to overcome this issue. Thank you, Regards, Karthikumar -- Are you =EXP(E:RT)

$$Excel-Macros$$ Excel macros using a mapping table

Hi, I have a file that is a source to feed into other. And they have different headers with same meaning, SO we have created a mapping table between the two data. A macro has to be designed to allow data to compare headers and fill the other file. So far i kinda forumalted this. But it is lea

$$Excel-Macros$$ Outlook to Excel Macros

Hi, I am working on a code to retrieve emails onto excel and then check if they have been responded and if so, how long did it take to respond. This is business requirement and hence help would be much appreciated. So far, I have code that retrieves all emails that have been responded and the

Re: $$Excel-Macros$$ Re: Need help

Yes, can you pls suggest the alternative code. Idea is when comboboxes are empty then it should run only on dates. Cheers Karthik On Tuesday, 29 March 2016 20:01:03 UTC+5:30, Paul Schreiner wrote: > > Ah... > I think maybe we should rethink the logic here. > In your statement

$$Excel-Macros$$ Re: Need help

act from outlook mailbox. Date picker for from and to dates and comboboxes are for sender and categories. Now my point is when I enter only dates then it should pull all emails between those dates. When I add sender to it then it should filter accordingly. Currently, if i do not enter all crite

$$Excel-Macros$$ Need help

rngD4) Then Worksheets("Data").Rows(r).EntireRow.Copy Destination:=wshP.Range("A" & wshP.Rows.Count).End(xlUp).Offset(11 + n, 0) Application.CutCopyMode = False n = n + 1 End If I think change needed here when any of the criteria poi

$$Excel-Macros$$ Re: Introduce Yourself !!

Hello All, I am Karthik. I have been using excel VBA for more than 10 years now. Have always been amazed at the power of excel VBA. Regards, Karthik -- 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 Help

Hi Vaibhav Thanks for replay, But one small doubt SNo Gender Name Shift InTime OutTime Tot. Dur. Gents Ladies 2 MR karthik Sam 01:44 21:52 4:36 Yes - 3 MR ANAND GS 09:28 21:16 7:42 Yes - Intime 8 MR NIRMAL GS 09:28 21:18 10:14 Yes - <09:30 12 MR RAJI GS 10:22 22:35 10:48 Yes - >

Re: $$Excel-Macros$$ Need Help

Dear Sir, How many ladies came before 9.30 and left 7.30 SNo Gendal Name Shift InTime OutTime Tot. Dur. Gents Ladies 1 Ms Priya S GS 9:30 19:30 10:00 - Yes 2 Mr karthik Sam 01:44 21:52 4:36 No - 3 Mr ANAND GS 09:28 21:16 7:42 No - 4 Mr Kavirajan ST GS 10:03 19:08 8:46 No - 5 Mr SURESH

$$Excel-Macros$$ Need Help

-- *Regards* karthik -- 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 RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Re: $$Excel-Macros$$ Please Answer the Question

Dear Team, Thank you to all. Regards karthik. On 4/5/13, Kuldeep Singh wrote: > A *Management Information System* (*MIS*) provides information that > organizations need to manage themselves efficiently and effectively.[1] > Management information systems are typically computer sys

$$Excel-Macros$$ Please Answer the Question

Dear Team Please Answer the Question What is the MIS ?,Explain. Regards karthik -- 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 RULES 1) Use concise

Re: $$Excel-Macros$$ Please Help

Hi Jayseel, Thank you for your replay, But i needed the In between Two difference date Hour & min Thanks Karthik.N On Wed, Jan 9, 2013 at 8:17 PM, Jaysheel Bhasme wrote: > Hi Karthik, > > Please check if this your requirement, > > Regards, > Jaysheel > > >

$$Excel-Macros$$ Please Help

Dear Help Please help for below attached file. -- *Regards* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and

$$Excel-Macros$$ Need help

Hi Exports, Pls find the attached file. -- *Regards* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Ad

$$Excel-Macros$$ Need help

Dear Team I want the performance count total allocate to Agency fe , date wise for done,dp Thanks karthik.N -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Po

$$Excel-Macros$$ Need help

Hi Team, Please help in the attachment file Regards karthik.N -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, N

Re: $$Excel-Macros$$ I want to learn macro from basic level

Hi Rajan My mail id is n.karthi...@gmail.com kindly send the same Regards karthik.N On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma wrote: > Excel Power programming with VBA J > > ** ** > > Either you can download from internet its free or I will send you on your > email id .. > > Really

$$Excel-Macros$$ Need macro website

Hi Friends, How learn the macro's in step by step,kindly provide the any macro tutorial website Pls Help Regards karthik.N -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro

Re: $$Excel-Macros$$ Need Help

Thank You Regards karthik.N On Thu, Mar 8, 2012 at 9:56 AM, NOORAIN ANSARI wrote: > see attached sheet.. > > > On Wed, Mar 7, 2012 at 3:12 PM, karthik N wrote: > >> Kindly help me >> >> To allocate the data in macro branch wise and every branc

Re: $$Excel-Macros$$ Need Help

FYI. Regards karthik.N On Wed, Mar 7, 2012 at 1:05 PM, NOORAIN ANSARI wrote: > Dear Kartik, > > Can you share sample workbook. > > On Tue, Mar 6, 2012 at 6:35 PM, karthik N wrote: > >> Kindly help me >> >> To allocate the data in macro branch wise and eve

$$Excel-Macros$$ Need Help

Kindly help me To allocate the data in macro branch wise and every branch shouid be save in new book , Regards, karthik.N -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

$$Excel-Macros$$ MyVlookUp

Hi... Whats this MyVlookUp thing please clarify -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ h

Re: $$Excel-Macros$$ Using macro move sheets from one work book to another work book

can i get the macro for my request On Mon, Jan 11, 2010 at 11:30 AM, grlinks-karthik wrote: > I need to copy the sheets from one work book to another work book, can > any one help is urgent > > I have to work book name called “destination.xls” and “source.xls”, > destination

Re: $$Excel-Macros$$ Password Cracker file

Attach the file On Tue, Jan 5, 2010 at 5:07 PM, Prathap . wrote: > Hi There.. > > > > I have excel file which is protected. > > > > Can anyone please help crack the password. If possible, then pls tell > me. Keeping the confidentiality in to consideration i can mail the excel > file to the concer

$$Excel-Macros$$ How to Clear the Cells

Hi all am new to this grp.. Happy New Year. Query: in macros how it can be programmed to clear the cells , except cells containing formulae or links etc(means cells having "=...) please help me -- -- So

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

Windows("paybill.xls").Activate > Range("A2:A3").Select > ActiveSheet.Paste > Range("A2:A3").Select > End Sub > * > > Can you debug once and let me know at which line you are getting the error. > It is working fine for me. > Make sure

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

aybill.xls").Activate > Range("A2:A3").Select > ActiveSheet.Paste > Range("A2:A3").Select > End Sub* > > Regards, > Praveen > On Thu, Dec 24, 2009 at 1:30 PM, grlinks-karthik wrote: > >> Hi >> >> I have Two sheets Nam

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

ndows("paybill.xls").Activate > Range("A2:A3").Select > ActiveSheet.Paste > Range("A2:A3").Select > End Sub* > > Regards, > Praveen > On Thu, Dec 24, 2009 at 1:30 PM, grlinks-karthik wrote: > >> Hi >> >> I ha

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

in diffirent sheets, I need code for that, these are sample sheets, based on your code i need to my modification , Please do the needful ASAP Regards grlinks On Wed, Dec 23, 2009 at 11:30 PM, kvc praveen kumar wrote: > Hi Karthik, > > What is the data that you want to copy and into w

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

Hi thank you for your reply, let me explain my requirement , On Wed, Dec 23, 2009 at 11:30 PM, kvc praveen kumar wrote: > Hi Karthik, > > What is the data that you want to copy and into which shet you want to > copy. > > On Wed, Dec 23, 2009 at 12:07 PM, grlinks-karthik wrot

$$Excel-Macros$$ How to calculate Interest Using VBA In excel

> Dea All > Could you please help me > > On 10/29/09, grlinks-karthik wrote: >> >> I need to calculate in interest excel sheet could any one help me with? >> >> >> >> Its like insurance calculation method, user will pay premium yearly &g

$$Excel-Macros$$ Re: How to calculate Interest Using VBA In excel

gt; > On 10/29/09, grlinks-karthik wrote: >> >> I need to calculate in interest excel sheet could any one help me with? >> >> >> >> Its like insurance calculation method, user will pay premium yearly >> basis, Period 20 years >> >> Conditi

$$Excel-Macros$$ How to calculate Interest Using VBA In excel

I need to calculate in interest excel sheet could any one help me with? Its like insurance calculation method, user will pay premium yearly basis, Period 20 years Conditions 1.Bonus will be calculated from 4th year onwards 2. 1 year -30%, 2nd year 10%, 3 year -10% will be deduc

$$Excel-Macros$$ Re: Multiply and/divide with a number

Could you send your requirement as attachment, then we can give solutions for that On Wed, Jul 29, 2009 at 2:03 PM, balbirkumar . wrote: > > Hi Friends > > I want to multiply all cells in the excel sheet with a particular number. > > please help > > With > Thanks & Regards > > Balbir Kumar > > >

$$Excel-Macros$$ Re: find next empty cell address

Dear Dave this is the method i expect , it's working fine, thanks for your help On Fri, Jun 5, 2009 at 4:22 AM, Dave Bonallack wrote: > Hi, > Try this: > A = Cells(Rows.Count, 1).End(xlUp).Row + 1 > This will give you the first blank row number > Regards - Dave. > > --

$$Excel-Macros$$ find next empty cell address

Dear All my data started in colomn "A" cell no 6 upto a50(Cell a1 to a5 is empty), using Vba I need to find the next empty cells address Could help me to find the next emty cell address through Vba in perticular coloumn Regards Grlinks www.grlinksindia.com --~--~-~--~~~--

$$Excel-Macros$$ Re: request to hlp me on the attached file query

Hi could Explain how you did?? On Sun, Dec 28, 2008 at 8:26 PM, Mr. Pardeshi Somnath wrote: > Hi... > Please Try Sheet Reply > Is This fine? > > > > Somnath C Pardeshi > +91 9221700131 > > > > -- > > Date: Sat, 27 Dec 2008 13:30:00 +0530 > From: kona...@gmai

$$Excel-Macros$$ Re: Can I get Day from date in excel.

Look at this link http://www.mrexcel.com/archive/Dates/29314.html this s workin fine 9-Oct-2008 Wednesday 10-Oct-2008 Thursday 11-Oct-2008 Friday 13-Oct-2008 Sunday On Mon, Oct 13, 2008 at 11:51 PM, Mayank Patel <[EMAIL PROTECTED]> wrote: > Hi friends, > Is there any worksheet function to

$$Excel-Macros$$ Re: Concatenate Formula

Hi, Use this formulae: =CONCATENATE(E17,F17,TEXT(G17,"[$-409]d-mmm-;@")) COL: E F G ROW ms excel 24-oct-2008 E17 is ms F17 is excel g17 is 24-oct-2008 I hope this helps. with regards karthik.B On Fri, Oct 24, 2008 at 1:01 AM, H Upadhyay <[EMAIL PROTECTE