Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congrats. On 1/5/12, Venkat CV wrote: > Congrats...Rajan& All... > > -- > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile * > * > * > > On Wed, Jan 4, 2012 at 11:29 PM, Ayush Jain wrote: > >> Sam, Welcome back to the group.

RE: $$Excel-Macros$$ Test XL 2007 code on XL 2010

Hi Kris, Takes a little more time/energy to debug when not familiar with the code and data, but see if this helps.. if not I can look at it further: The code to create the Result sheet never executes because n = 0 at that point n = 0 because the value of n was never set in executed code thus

$$Excel-Macros$$ doubt with rounding off and change event in excel vba

Dear Experts I am attaching an excel vba file. In which I am facing a problem with change event. the addition of textbox2.text + textbox3.text values with the value of 3% of the value of the above both. That 3% value if exceeds 1 rupee it should be rounded off to the next nearest 10 rs. eg: i

Re: $$Excel-Macros$$ what is different between .value and .value2

Dear Chandra, Thanks for your excellent question The difference between Value and Value2 is that 1) Value2 always uses the same value that Excel uses. It does not truncate decimal places like when you divide 22 by 7 and format the cell for 2 decimal places, value 2 will give you the maximum

Re: $$Excel-Macros$$ Prices from NSE website

Don - The URL is http://www.nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD Rajan - I need this for excel 2007. Please send a screenshot for 2007 excel. On Wed, Jan 4, 2012 at 7:29 PM, Rajan_Verma wrote: > You can Import data from WEB using FROM WEB option

$$Excel-Macros$$ what is different between .value and .value2

Dear all What is different between .value and .value2 can you explain with range ("a1:a100") .value= .value2 end with with range ("a1:a100") .value= .value end with or with range ("a1:a100") .value2= .value2 end with i do't know how do normally use which is performance best ? [ Fast

$$Excel-Macros$$ Merging Sheets from Multiple files

Thanks in advance for your help - i am looking for some vba code to accomplish the following I have approx 200 workbooks which have been created from a master template and should be identical. Each one represents a budget for a specific property location. They are located in multiple folders (e

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congrats...Rajan& All... -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * On Wed, Jan 4, 2012 at 11:29 PM, Ayush Jain wrote: > Sam, Welcome back to the group. We missed you. > > Noorain, I liked the poetic wishes. Keep it up

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Sam, Welcome back to the group. We missed you. Noorain, I liked the poetic wishes. Keep it up. Thanks everyone for being the part of this group. Regards Ayush Jain On Wed, Jan 4, 2012 at 11:20 PM, Aamir Shahzad wrote: > Congratulates Rajan. Wellcome back SAM. > > > On Wed, Jan 4, 2012 at 7:

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congratulates Rajan. Wellcome back SAM. On Wed, Jan 4, 2012 at 7:37 PM, Rajan_Verma wrote: > Thank you all. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *SWADHEEN JAIN > *Sent:* Jan/Wed/2012 02:27 > *To:* excel-macros@googlegroups.com > *S

Re: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

You also can use Offset for Invoice =OFFSET($H$1,MATCH(A32,$H$1:$H$16,0),-5) for data =TEXT(OFFSET($H$1,MATCH(B32,$H$1:$H$16,0),-7),"m/dd/") Regards, Aamir Shahzad On Wed, Jan 4, 2012 at 8:32 PM, NOORAIN ANSARI wrote: > Dear chandra, > > You can also use VLookup... > > *=VLOOKUP($

Re: $$Excel-Macros$$ Test XL 2007 code on XL 2010

Hi Guys, Thanks for testing the code. Can you please debug the code ? I want to know which command/keyword likes XL 2007 but not XL 2010. Thanks Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Ur

Re: $$Excel-Macros$$ Test XL 2007 code on XL 2010

Kris, Tested fine on 2007 but it DID nothing but give me 52 & 0 msgbox’s and does NOT create the new sheet Don Guillett SalesAid Software dguille...@gmail.com From: Kris Sent: Wednesday, January 04, 2012 9:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Test XL 2007 code on

RE: $$Excel-Macros$$ Test XL 2007 code on XL 2010

Hi Krishna Its not working on Excel 2010 . Only massage are apprearing 52 and 0 Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Jan/Wed/2012 08:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Test XL 2007 code on XL

Re: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

Dear chandra, You can also use VLookup... *=VLOOKUP($A32,CHOOSE({1,2},$H$2:$H$16,$C$2:$C$16),2,0)* See attached sheet.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Test XL 2007 code on XL 2010

Hi, Can anyone test this code on XL 2010? It works fine on XL2007. But I was told it fails on XL 2010. Appreciate any comments. Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ Fwd: V lookup using macros

Paul, Another way to limit this is with named ranges. For one client I developed a macro that looked at certain criteria and created the named ranges which limited the vlookups to small blocks. Don Guillett SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Wednesday, January 0

$$Excel-Macros$$ Cash flow Date selection error

Dear Mr. Rajan, Have you seen my Cash flow Date selection Problem Please... Chandru -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will

Re: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

Dear Rajan, Thanks , it is working fine Regards chandru On Wed, Jan 4, 2012 at 8:20 PM, Rajan_Verma wrote: > You can use this Simple Function: > > =INDEX($A$1:$I$16,MATCH(A32,$H$1:$H$16,0),1) > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.co

RE: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

You can use this Simple Function: =INDEX($A$1:$I$16,MATCH(A32,$H$1:$H$16,0),1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Jan/Wed/2012 08:09 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TI

Re: $$Excel-Macros$$ Fwd: V lookup using macros

I know this doesn't necessarily address your specific problem, but I have a recommendation for you. If your files are 4Mb+, then that implies thtat you have a lot of rows. in which case, vLookups can be time consuming. I have sample data of 100,000 rows. and the lookup sheet has 80,000 rows. usin

$$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

Dear all, do you sugguest any other formula is there . [ MY Formula sheet attached] Regards durai.chandra sekaran.(Chandru) -- 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$$ Rajan verma : Most Helpful Member- Dec'2011

Thank you all. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SWADHEEN JAIN Sent: Jan/Wed/2012 02:27 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011 Thank you Rajan ji for your devotion and

Re: $$Excel-Macros$$ Urgent help required

Hi Paul, Can you do a favour for me ? ping me your mail ID at: excelfox at live.in Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Delete date

You are welcome !! Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't pos

Re: $$Excel-Macros$$ Urgent help required

It appears that Paul has solved it for you. Don Guillett SalesAid Software dguille...@gmail.com From: nitin arora Sent: Wednesday, January 04, 2012 7:52 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help required Hi Don, My apologies for the subject and I promise t

Re: $$Excel-Macros$$ Delete date

Hi Kris, Thanks a lot its working, now and i am getting perfect data thanks a lot kris. Thank you. Regards Lokesh.M On Wed, Jan 4, 2012 at 7:35 PM, Kris wrote: > Hi, > > Try this macro. > > Sub kTest() > > Dim k, i As Long, s As String, Flg As Boolean > Dim x, r As Range, txt As Strin

Re: $$Excel-Macros$$ Urgent help required

What you're asking is very simple using VBA. The question is:  do you know how to use VBA?  A quick solution would look like: Option Explicit Sub Split_Errs()     Dim R, nRows, dRow, strArray, inx     dRow = 1     nRows = Application.WorksheetFunction.CountA(Sheets("Sheet1").Range("A1:A65000"))  

Re: $$Excel-Macros$$ Delete date

Hi, Try this macro. Sub kTest() Dim k, i As Long, s As String, Flg As Boolean Dim x, r As Range, txt As String Set r = Range("a2:a" & Range("a" & Rows.Count).End(3).Row) k = r With CreateObject("scripting.dictionary") .comparemode = 1 For i = 1 To UBo

RE: $$Excel-Macros$$ Urgent help required

Hi Do you want this procedure Only in AB Column..? Regards Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of nitin arora Sent: Jan/Wed/2012 12:51 To: excel-macros Subject: $$Excel-Macros$$ Urgent help required Hi, Please find attached excel

RE: $$Excel-Macros$$ Fwd: V lookup using macros

You can use this in VBA. strResult=Application.Vlookup(LookUpvalue,LookupRange,ColNumber,MatchType) Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of nitin arora Sent: Jan/Wed/2012 11:01 To: excel-macros Subject: $$Excel-Macros$$ Fwd: V loo

Re: $$Excel-Macros$$ Fwd: V lookup using macros

I cleaned up your code somewhat. Without seeing the file, hard to say but maybe the on error will do. Hope this helps Sub Macro3() Dim lr As Long ‘added On Error Resume Next ‘ 'suggest adding lr = Cells(Rows.Count, 1).End(xlUp).Row 'then use Range("$A$1:$X$" & lr)for all ‘=== With Ra

RE: $$Excel-Macros$$ Prices from NSE website

You can Import data from WEB using FROM WEB option in Get External Data. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sharad jain Sent: Jan/Wed/2012 11:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Prices from NSE website Hi,

Re: $$Excel-Macros$$ Delete date

Hi Kris, Its not working, please put button on attached excel fine and send it to me. Please test once and send back to me sir. Regards lokesh.M On Wed, Jan 4, 2012 at 7:19 PM, Kris wrote: > Hi > > You could try this macro. > > Sub kTest() > > Dim k, i As Long, s As String, Flg As Boolean

Re: $$Excel-Macros$$ Urgent help required

Hi Don, My apologies for the subject and I promise this wont happen in future. As far as "Me" is concerned I am relatively new to this concept of groups so i have no Idea where should I go to change it to my name. Any help on this front would be highly appreciated. As far as the request is concer

RE: $$Excel-Macros$$ Could you please explain why are we using -- in this formula

"- - " sign Convert TRUE/False Result to 1/0, it make Formula debugging easier .. See the attached file Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sundarvelan N Sent: Jan/Wed/2012 11:31 To: excel-macros@googlegroups.com Subject: $$Excel-M

Re: $$Excel-Macros$$ Delete date

Hi You could try this macro. Sub kTest() Dim k, i As Long, s As String, Flg As Boolean, x k = Range("j2:j" & Range("j" & Rows.Count).End(3).Row) With CreateObject("scripting.dictionary") .comparemode = 1 For i = 1 To UBound(k, 1) k(i, 1) = Re

Re: $$Excel-Macros$$ Happy Birth Day

Thank you very much RAM.. On Wed, Jan 4, 2012 at 6:54 PM, Ram wrote: > Happy Birthday Noorain > > Sent from my iPhone > > On Jan 3, 2012, at 9:34 AM, NOORAIN ANSARI > wrote: > > Thank you very much to all of you. > > > -- > Thanks & regards, > Noorain Ansari > *http

Re: $$Excel-Macros$$ Happy Birth Day

Happy Birthday Noorain Sent from my iPhone On Jan 3, 2012, at 9:34 AM, NOORAIN ANSARI wrote: > Thank you very much to all of you. > > > -- > Thanks & regards, > Noorain Ansari > http://excelmacroworld.blogspot.com/ > http://noorain-ansari.blogspot.com/ > > On Mon, Jan 2, 2012 at 8:22 PM, Ra

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Ditto, and welcome back Sam. Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Tuesday, January 03, 2012 9:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011 Guys, been back from the UK after giving

Re: $$Excel-Macros$$ Urgent help required

FIRST. To some of us, ME, “urgent help required” is a NO NO. All requests are urgent. Now, you will need to explain the logic of what you want. If you want to find every comma on the sheet, what will you do with numbers, etc? You need to specify which columns to search and you need to tell us wh

Re: $$Excel-Macros$$ Fwd: V lookup using macros

Hi Noorain, I am extremely sorry for the mistake. However all the files that I have are of more than 4 mb in size and gmail is not allowing me to send more than 4 mb of data. I am pasting the codes for macro 3 used in the sheet . Please let me know if there is any other way by which i can upload t

Re: $$Excel-Macros$$ Prices from NSE website

Please provide a URL Don Guillett SalesAid Software dguille...@gmail.com From: sharad jain Sent: Wednesday, January 04, 2012 12:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Prices from NSE website Hi, Is there any way to extract current / closing price of a particular sha

Re: $$Excel-Macros$$ Delete date

Dear Lokesh, Please try it.. Sub Delete_Date() For Each Rng In Sheet1.UsedRange If IsDate(Rng) = True Then Rng.EntireRow.Delete End If Next End Sub On Wed, Jan 4, 2012 at 6:23 PM, lokesh wrote: > Hi Rajan > > As discussed, you have solved this query very quickly but i need some > changes beca

$$Excel-Macros$$ Delete date

Hi Rajan As discussed, you have solved this query very quickly but i need some changes because of every time when i am pulling the data in the application that time below mentioned names are changed every time. so want in one click it shows what ever names are there in cell A those names comes her

Re: FW: $$Excel-Macros$$ cashflow statement

Dear sir, could you plese provide soulution sir, Regards chandru On Tue, Jan 3, 2012 at 8:24 PM, chandra sekaran wrote: > Dear Rajan, > > if i select Month july only july data will come but all data comes > output sheet after that i little bit change from date , To date it is > wor

Re: $$Excel-Macros$$ Fwd: V lookup using macros

Dear Nitin, Attached File is in protected mod, we are unable to view Macro 3 On Wed, Jan 4, 2012 at 11:00 AM, nitin arora wrote: > > Hi, > > I am facing a problem with Macro 3 in the sheets attached. At times the > macro woks fine and at times it does not. The reason for the same is that > whe

Re: $$Excel-Macros$$ Happy Birth Day

happy birthday noorri On 1/4/12, Asa Rossoff wrote: > Happy birthday, Noorain! > > Asa > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Rajan_Verma > Sent: Monday, January 02, 2012 6:52 AM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macr

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Thank you Rajan ji for your devotion and time for the group. God bless you. Swadheen Jain On Wed, Jan 4, 2012 at 12:59 PM, Maries wrote: > *Congrats Rajan!* > > On Wed, Jan 4, 2012 at 10:37 AM, Asa Rossoff wrote: > >> Congratulations, Rajan! You bring a lot to the group -- you're very >> ge