$$Excel-Macros$$ Vlookup Book

2012-10-29 Thread Amit Desai (MERU)
Dear Noorain, Few days back you were referring a book to be written on vlookup. If you have completed, could you please share the same with the Group? Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may

Re: $$Excel-Macros$$ Vlookup Book

2012-10-29 Thread noorain . ansari
Dear Amit, Currently i am out of station. Will share it shortly Sent from BlackBerry® on Airtel -Original Message- From: Amit Desai (MERU) amit.de...@merucabs.com Sender: excel-macros@googlegroups.com Date: Mon, 29 Oct 2012 14:25:27 To: excel-macros@googlegroups.com Reply-To:

RE: $$Excel-Macros$$ Vlookup Book

2012-10-29 Thread Amit Desai (MERU)
Thanks a lot. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of noorain.ans...@gmail.com Sent: 29 October 2012 17:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Book Dear Amit, Currently i am out of station.

Re: $$Excel-Macros$$ The first sheet to be opened always in an excel file

2012-10-29 Thread Vijay Kr. Aggarwal
Hi Pravin, Please find attached files for both type (Auto and Workbook) of code. regards, Vijay On 10/27/12, Pravin Gunjal isk1...@gmail.com wrote: *Hello Mr. Paul / Vijay / Prince,* * * *I have put macros in ThisWorkbook and checked but it's not working.* *Following is the macro.* * *

$$Excel-Macros$$ Re: Compre cells, extract string which makes difference

2012-10-29 Thread Paul Schreiner
Your example seems to imply some assumptions. Is the value in column 2 ALWAYS longer than the value in column 1? What if the values are: ABC1alpha and ABC1beta what do you want in the third column? When you said that you want to extract the characters, does that mean that you want the first

$$Excel-Macros$$ Re: Projects Pipeline sheet updation

2012-10-29 Thread Don Guillett
Why not make your life easier and use ONE sheet for all wtih an extra column for the name and then use filter to see the individuals as desired On Monday, October 29, 2012 6:22:14 AM UTC-5, Pooja S wrote: Hi Team, Attached is the sheet where in i need some formula to get the below

Fwd: $$Excel-Macros$$ The first sheet to be opened always in an excel file

2012-10-29 Thread Pravin Gunjal
*Thanks a lot Mr Vijay and Mr Paul.* -- Forwarded message -- From: Vijay Kr. Aggarwal vjaggarwal2...@gmail.com Date: Mon, Oct 29, 2012 at 5:36 PM Subject: Re: $$Excel-Macros$$ The first sheet to be opened always in an excel file To: excel-macros@googlegroups.com Hi Pravin,

Re: $$Excel-Macros$$ Re: Projects Pipeline sheet updation

2012-10-29 Thread Zibraan
Exactly my point is the same but all sheets come from different circle offices, i just need to check it manually and forward the same to boss. Regards, Lucky On Mon, Oct 29, 2012 at 6:34 PM, Don Guillett dguille...@gmail.com wrote: Why not make your life easier and use ONE sheet for all wtih

Re: $$Excel-Macros$$

2012-10-29 Thread Chandra Shekar
Hello, Could you please help on the below mail. Thanks in advance. Regards, Chandru On Fri, Oct 26, 2012 at 4:50 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, I am trying to send mail from Lotus Notes when I run the program. I am getting window saying(Pls check jpg

Re: $$Excel-Macros$$ Macro for Find

2012-10-29 Thread Vijay Kr. Aggarwal
Hi Shrinivas, Please check attached file. I hope this will answer your query. regards, Vijay On 10/27/12, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear all I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example .-: user want to find details of H.then macro

$$Excel-Macros$$ Re: Projects Pipeline sheet updation

2012-10-29 Thread Don Guillett
Should do it in .xlsM workbook. Sub getallSAS() Dim i As Long Dim cr As Double Application.ScreenUpdating = False ActiveSheet.UsedRange.Offset(1).Clear On Error Resume Next For i = 2 To Sheets.Count With Sheets(i) cr = Application.Match(contact, .Columns(1), 0) .UsedRange.Offset(cr).Copy

Re: $$Excel-Macros$$ 'Useless subject' was: Need Macro or formula to work on attached file

2012-10-29 Thread David Grugeon
I am not going to spend my time downloading your file untill I know what it is you want. Please do us the courtesy of copying the steps from the file and putting them in your post. Also put a more relevant subject heading. Regards David Grugeon On 30 October 2012 03:15, ankur kochar

Re: $$Excel-Macros$$ Vba code to intract with Web Page to upload a file

2012-10-29 Thread David Grugeon
I think you need to explain a bit more - what does ' local file in a web page' mean? Is your file local (e.g. on C:\ drive or is it on the internet? If it is in the cloud - what cloud application are you using? If it is local why do you need to use the web to find it? Are you using a google