$$Excel-Macros$$ Re: Is this possible and how

Hi Alex, Not sure if this is helpful, but it's something to consider. A macro can identify the button that called it, and the text on that button. So you can have just one macro, with lots of different buttons calling it. The code within the macro can do different things depending on which but

$$Excel-Macros$$ Opening excel workbook-Password recovery

Hi Excel mahagurus, First of all, I appreciate this group and especially the troubleshooter members very much and pay my highest regards to them. My query is that, I need to open an excel workbook which requires password.Have already tried my hand on some recovery softwares but no luck as of

$$Excel-Macros$$ Re: Displaying fixed time everyday

Thanks a lot Paul for your effort to explain in great detail. It certainly helped me to solve the problem. Best Wishes Praveen Khunte Lead Engineer E praveen.khu...@gmail.com Alstom Projects India Ltd -

$$Excel-Macros$$ Re: Displaying fixed time everyday

Thanks a lot Dilip It worked out and solved my problem. I was in dilemma that the cell needs to be displayed in TIME format. Anyways thanks to the TEXT feature and YOU. Best Regards Praveen Khunte Lead Engineer E praveen.khu...@gmail.com ---

$$Excel-Macros$$ Re: Excel Query

Thanks very much dear. I appreciate your effort. Keep it up this good work. Thanks, Imran On Tue, Oct 20, 2009 at 9:28 PM, Dilip Pandey wrote: > Hi Imran, > > Attached file has been solved as per your requirements. Let me know if you > face any challenge(s). > > Best Regards, > -- > DILIP KUM

$$Excel-Macros$$ Is this possible and how

Hi all in VBA 6.5 I have this code that i was supplied by one off your members which works fine: On Error GoTo Ext: Dim X As Range Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks) X.Cells(1, 1) = 7 X.Cells(1, 2) = 58 Ext: Exit Sub Having used this code on 50 Option buttons and changing the

$$Excel-Macros$$ Re: MYEXTRACT

Hey Michael.. Here u go Function MyExtract(MyText As String, ItemNo As Integer, FrontOrBack As String, Optional MySeparator As String) As String ' This function will scan a string containing at least TWO words, each separated ' by a specified character and extract one of the words. It

$$Excel-Macros$$ Re: Excel Compare two columns of text data

Hi, Great if you found the solution using SQL. I have given a try to the query using Excel functions only. Just replied on your main posting, a minute back. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com Ne

$$Excel-Macros$$ Re: Excel Compare two columns of text data

Dear Chirag Shah, Use below formulae. Both of them should be applied and considered for exact match. If you want you can merge both the formule in a single formula using nesting technique. {=IF(ISNUMBER(MATCH("*"&IF(ISERROR(MID(B2,FIND(" ",B2)+1,FIND(" ",B2,FIND(" ",B2)+1)-FIND(" ",B2)-1)),RIGHT

$$Excel-Macros$$ Re: Excel Query

Hi Imran, Just answered this one a minute ago. Suggestion:- Please do not send seperate emails for same query. :) Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/20/09, Imran khan wrote: >

$$Excel-Macros$$ Re: Displaying fixed time everyday

That's NOT what you first said. You said you wanted an EVENT to run ONLY after 10:00am. Now, if you use: =TODAY()+0.41667 Then, it will always show "today"'s date and 10:00am (you have to format it as custom format: m/d/ hh:mm:ss AM/PM but that means that if you open the file any time after

$$Excel-Macros$$ Re: Displaying fixed time everyday

Hi Praveen, Try below formula and check it by changing system date. =TEXT(IF(AND(HOUR(NOW())>=10,MINUTE(NOW())>=0, SECOND(NOW())>0),TODAY()+1,TODAY()),"dd-mmm-") & TEXT(TIME(10,0,0)," hh:mm AM/PM") Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan

$$Excel-Macros$$ Re: Displaying fixed time everyday

Hi Dilip Thanks for the effort.It gave me sound idea of manipulating date. However, I would like to reiterate the problem. The cell displays 10/20/2009 10:00AM on 20th October. Can I display 10/21/2009 10:00AM on the same cell automatically when I open the file to 21st October. This means that dyn

$$Excel-Macros$$ Re: Query!!!!

Hi, U r right, see i need to deduct the cumulative customers...plz find attached sheet for ur reference On Tue, Oct 20, 2009 at 2:12 PM, Anubhav Somani wrote: > Hi Himadri, > > I m not sure if i hv understood the query correctly, pls clarify... > U are unable to give the effect of customer re

$$Excel-Macros$$ Macro Help

Hi All, Q1) - Some cells/columns/sheets doesn't allow the paste values(copy from one sheet) e.g : if i copied from one sheet to another sheet , excel show popups enter manually,don't copied form other sheet. Q2) - If I put the value in one cell then click enter , cell value automatically change

$$Excel-Macros$$ Re: MYEXTRACT

Hey Michael.. Here u go Function MyExtract(MyText As String, ItemNo As Integer, FrontOrBack As String, Optional MySeparator As String) As String ' This function will scan a string containing at least TWO words, each separated ' by a specified character and extract one of the words. It

$$Excel-Macros$$ Re: Plz help in this problem (excel)

good reply manish - Original Message From: Ayushj To: MS EXCEL AND VBA MACROS Sent: Wed, October 14, 2009 8:36:33 AM Subject: $$Excel-Macros$$ Re: Plz help in this problem (excel) Hi Abdul, You can use ceiling function to get the desired output. CEILING(number,significance) Exam

$$Excel-Macros$$ Re: Query!!!!

Hi Himadri, I m not sure if i hv understood the query correctly, pls clarify... U are unable to give the effect of customer reduction once a client leaves. I assume that wn a client leaves, all customers linked to that client also go off?? right?? If i m right, do you have any data (or summary) of

$$Excel-Macros$$ Re: Query!!!!

Hi Upendra, Thanks for your reply but each client is adding customers every month, in that case i think it wont work, plz help me On Tue, Oct 20, 2009 at 5:11 PM, Upendra Singh wrote: > Hi Himadri, > > > > > > You should multiply new client with customer per client. > > > > > > Thanks and Re

$$Excel-Macros$$ Re: Displaying fixed time everyday

Hi Praveen, Try below formula:- =IF(AND(HOUR(NOW())>=10,MINUTE(NOW())>=0, SECOND(NOW())>0),TODAY()+1,TODAY()) Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Oct 20, 2009 at 7:18 AM, Prave

$$Excel-Macros$$ Re: MYEXTRACT

I'm sorry, but in Excel2007, I do not find a function called "MYEXTRACT" neither in VBA or the Excel functions. try this:  Go to the Function Wizard. In the pull-down box that has 'select a category', select "User Defined". Does the function "MYEXTRACT" appear here? I suspect that someone has w

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

Hi, Regarding point no. 2:- > Try hiding one sheet among three available sheets and after that protect Workbook not worksheet. As I have Excel 2003, I am not into the position to explain further in relation to Excel 2007. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91

$$Excel-Macros$$ Re: Query!!!!

Hi Himadri, You should multiply new client with customer per client. Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Himadri Roy Sent: Monday, October 19, 2009 9:50 PM To: excel-macros@go