$$Excel-Macros$$ Re: Auto compleate in Validation

Umesh, You are welcome...!! And thanks for the intelligent query. Please do share these type of queries. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/1/09, Umesh Gupta 3 wrote: > > thank

$$Excel-Macros$$ Re: Auto complete list popup windo in excel

Hi Vidyut, As per my knowledge, you can set the validation by choosing any of the available option which are there in Data->Validation, but then you have to choose the desired item manually from the drop down.. Alternatively, if the data is already typed in the column, then Excel itself shows auto

$$Excel-Macros$$ Re: help plz

Hi Ashish, Attached workbook has the solution to your query. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/29/09, ashish koul wrote: > > hi i want to apply vlookup formula to gind the age of pe

$$Excel-Macros$$ Re: link cell-unlinked cell-double link cell

Hi Manoj, Thanks for coming with intelligent queries. I have explained some options in the attached workbook. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/29/09, Manoj Kukrej wrote: > >

$$Excel-Macros$$ Re: Inserting an animated gif in Excel

Thank you so much On 8/31/09, jonell wrote: > > On Aug 30, 10:43 pm, mahesh parab wrote: > > Dear All > > > > i am trying to insert gif image in Excel but its not working,I will > greatly > > appreciate any help on this, i herewith attach sample sheet, > > i got the steps form below mention li

$$Excel-Macros$$ Re: if statements to compare string

Hi Omoghene, I find the most straightforward way to achieve this kind of thing is to use the match function that Excel provides, wrapped up in your own function: Public Function FindString(ByVal rng As Range, ByVal str As String) As Integer On Error Resume Next FindString = Application.W

$$Excel-Macros$$ Re: Vlook up and filtering

you can name the range(s) as a variable and reference the variable On Aug 31, 2:08 am, Ashwin wrote: > Hi All, > I need to use Vlookup, The conditions is that the lookup range has > multiple value (Duplicate entries) and i need to select (lookup range > value ) based on next colum. Please help t

$$Excel-Macros$$ Re: message follow cursor

Hi Manoj, One approach could be that you can insert one row at the top of the each sheet and then apply the formula (Assest - Liabilities) and assign a Freeze pane on it. Now whenever you move anywhere on the sheets, you will have the difference on the top of each sheet. If you want, you can at

$$Excel-Macros$$ Re: Vlook up and filtering

Hi Ashwin, Can you share a sample spreadsheet containing your query and the result which you are looking for. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Aug 31, 2009 at 2:38 PM, Ashwin wr

$$Excel-Macros$$ Re: Disable Poups

For #2, I created a Before Close event: Private Sub Workbook_BeforeClose(Cancel As Boolean)     Me.Saved = True End Sub this basically sets the flag that indicates that the file has been changed to "true" so that it THINKS no changes have been made since the last time the file was saved. Paul

$$Excel-Macros$$ Re: Linking to Reuters market data in vba

Hi, Just to clarify my post. I'm looking for a way to access Reuters data in a VBA module (not a spreadsheet cell). The RtGet function works perfectly well in a spreadsheet cell, however when I try to use it in a function/sub in a vba module, it doesn't work. The workaround I'm using involves

$$Excel-Macros$$ Disable Poups

Hi All, I have a function which I am opening using the ShellExecute method to Print. I have two issues in doing the same. 1. For password protected files, I am not able to catch the password protected errors when I enter the wrong password. How do I catch the error with the above statement? 2. A

$$Excel-Macros$$ Fwd: Auto complete list popup windo in excel

-- Forwarded message -- From: vidyut more Date: Mon, Aug 31, 2009 at 1:27 PM Subject: Auto complete list popup windo in excel To: dilipan...@gmail.com, excel-macros@googlegroups.com Hi, Dilip  i know i am taking your time. I want to know is it possible in excel auto popup windo

$$Excel-Macros$$ Vlook up and filtering

Hi All, I need to use Vlookup, The conditions is that the lookup range has multiple value (Duplicate entries) and i need to select (lookup range value ) based on next colum. Please help to to get it. Regards, Ashwin --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: help plz

Maybe koul doesn't need this solution, for example, if there are more people in the sheets, how to do it? On Aug 30, 3:34 am, Ramkrishna Padhi wrote: > Hi Ashish, > > Please find the attached solution. > > Thanks & Regards, > Ramkrishna T. Padhi > > On 8/29/09, ashish koul wrote: > > > > > > >

$$Excel-Macros$$ Auto complete list popup windo in excel

Hi, Dilip i know i am taking your time. I want to know is it possible in excel auto popup windo when we type some party name which will appaer like Tally and other program. I know data validation. but in that we have to select. any solution. Thanks in advance. --~--~-~--~~---

$$Excel-Macros$$ message follow cursor

Hi Dilip, I have balance sheet Asset total 100 Liability total 90 Diff between two is shown below =1 cell which contain difference between two item/cell>> I want to see it on top/below wherever I move in worksheet like sheet 1,2 3 etc how I can make it diff Follow the mouse

Fw: Fw: $$Excel-Macros$$ Convert PDF to Excel (-PIN-)

Dear Subu, Try the following link. http://www.4shared.com/file/109162436/7d544124/Able2Extract1Professionalv6000_Cracked.html Regards, Mudassar Ramzan - Original Message - From: "Subu" To: "MS EXCEL AND VBA MACROS" Sent: Sunday, August 30, 2009 9:55 AM Subject: Re: