$$Excel-Macros$$ Macro Required

2014-02-26 Thread Prafull Jadhav
Dear All, Good After Noon, I require one macro for attached excel sheet. Appreciate cooperation expected from you. Regards, Prafull Jadhav 9920553518 -- 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$$ Macro Required

2014-02-26 Thread Ravinder
Pfa , first select a column till values in sheet 1 and then select range a2 in sheet2 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Wednesday, February 26, 2014 3:08 PM To: excel-macros@googlegroups.com;

Re: [XL-VBA Clinic] RE: $$Excel-Macros$$ Macro Required

2014-02-26 Thread Prafull Jadhav
Dear Ravinder Sir, Thanks for Reply..it is working fine. Can we make the same without selecting Range and paste range(Without message box)? Means we need not require fill the Range. Regards, Prafull Jadhav 9920553518 On 26 February 2014 16:59, Ravinder ravindervbacli...@gmail.com wrote:

Re: $$Excel-Macros$$ Alternate for concatenate in excel

2014-02-26 Thread Paul Schreiner
There's ALWAYS alternatives, but without more information, I have no way of knowing which would be preferable.   To ME, 500 is a small number (I deal with 10,000+) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all

Re: $$Excel-Macros$$ Long if-then function? HELP

2014-02-26 Thread Paul Schreiner
Could you send me the entire function? (you could send it directly)   Is there a relationship between the variables that influences the rate?   I think I'd like to look at nested Select statements.     Paul - “Do all the good you can, By all the means you

$$Excel-Macros$$ Two-dimensional interpolation

2014-02-26 Thread Gerrit Grundling
Greetings, all I have attached some aerofoil data for a Clark Y foil. This data is also available in my spread sheet. The Reynolds number is given in the heading as 5.00E+04, 1.00E+05, 5.00E+05, 1.00E+06 and 3.00E+06. I need to find Cl and Cd at an AoA for a Reynolds number: GetCl(AoA,

$$Excel-Macros$$ Database Query Macro- Password Prompt - Excel

2014-02-26 Thread pranav patil
I have created an Excel sheet that retrieves data from a ODBC source. I have created a macro using macro recorder to refresh the data by re-connecting to the database. However, the connection requires a password prompt and when the macro is run, you are still required to enter the password.

$$Excel-Macros$$ Problem with Advanced Filter

2014-02-26 Thread Hilary Lomotey
i have written a macro to extract couple of data from another sheet with advanced filter 'extracting equity statement Sheet24.Range(EqtyPDB).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheet19.Range( _ CW1:CX2), CopyToRange:=Sheet19.Range(CN1:CU1), Unique:=False immediately after this

$$Excel-Macros$$ Command Buttons in excel (office360)

2014-02-26 Thread Jack O'Leary
I have many many VBA excentuated files from previous version of excell (2000, 2003, 2007) where I have added a command button to a sheet, and then associated it with a subroutine on the sheet. In my newer version of excel, it appears the command button has been moved outside the scope of a

Re: $$Excel-Macros$$ Problem with Advanced Filter

2014-02-26 Thread mrExcel4u
Plz share your workbook Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Thu, Feb 27, 2014 at 2:06 AM, Hilary Lomotey resp...@gmail.com wrote: i have written a macro to extract couple of data from another sheet with advanced filter 'extracting equity statement

Re: $$Excel-Macros$$ Problem with Advanced Filter

2014-02-26 Thread Anil Gawli
Dear Hilary, U have to release the earlier filter i.e clear filter criteria and then apply the fresh one. Warm Regards, Gawli Anil. On Thu, Feb 27, 2014 at 9:06 AM, mrExcel4u mr.exce...@gmail.com wrote: Plz share your workbook Thanks regards, www.MrExcel4U.com On Thu, Feb 27, 2014 at

Re: [XL-VBA Clinic] RE: $$Excel-Macros$$ Macro Required

2014-02-26 Thread Anil Gawli
Dear Praful, Pl find the modified file as req. Warm Regards, Gawli Anil On Wed, Feb 26, 2014 at 5:18 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Ravinder Sir, Thanks for Reply..it is working fine. Can we make the same without selecting Range and paste range(Without message

$$Excel-Macros$$ Please send me add ins for number to text in xl

2014-02-26 Thread Ali Abbas
-- Forwarded message -- From: Dan Burfield danburfi...@gmail.com Date: Dec 4, 2013 3:06 PM Subject: $$Excel-Macros$$ need help with nested IF AND formula To: excel-macros@googlegroups.com Cc: Hi, thx in advance for your help. I am trying to build a spreadsheet that will help

$$Excel-Macros$$ VBA macro to read website using internet explorer

2014-02-26 Thread Aashish Watve
Hi All, I am using a VBA macro to access or update a external internet page using internet explorer. The internet explorer is opened in the background and then the site is opened. However, in recent Internet explorer versions, if I access a new page, the internet explorer goes offline and