$$Excel-Macros$$ Time Tracker

Hi All, Could you please help me to write a macro for saving the date and time in a spread sheet when the user lock the system, when the user open it also has to be captured. Many thanks for your help Kind regards Sumesh -- --

Re: $$Excel-Macros$$ Time Values in a variable

Thanks for your response, I made the change below: MonStart = Cells(Count, 8) * 24 MonStart = Format(MonStart, "##:##") But get this output: ":9" Any other suggestions? On 1 Dec, 15:35, Deepak Rai wrote: > Hi, > > You can use custom fromat to get that 09:00:00. > > Regards, > > Deepak Rai > >

$$Excel-Macros$$ Re: Help for if...match formula

Try this: =IF(SUMPRODUCT(--ISNUMBER(SEARCH(E2,A2:A6))),F2,"") I tested it and it worked. On Nov 29, 9:15 am, mahesh parab wrote: > Dear All > > In attach sheet i want to find matching text from another column, Can anyone > help for > formula.below mention formula is not working.i will appreciat

Re: $$Excel-Macros$$ Hide and unhide option

Dear Excel masters, Anyone know this solution or not? On Tue, Dec 1, 2009 at 1:12 PM, suresh k wrote: > Hi Excel masters, > > I have created a macro for maintaining attendance. > > In sheet 1 i have created a box, If i select Jan. It should go to 2nd sheet > and should show only tho

$$Excel-Macros$$ Re: Stumped with count if's

In L7: IF(K7="","",IF(K7>"",IF(OR(K7="a",K7="d",K7="n"),7,7.5))) I do have one question about the following: > In cell Y7 if d appears in K7 M7 O7 count as 1 > In cell Z7 if A appears in K7 M7 O7 count as 1 Should it count as 1 if all three columns are 'd' or is it either one, two, or all three

$$Excel-Macros$$ copy value if value within a cell matches value within other cell of other worksheet

I need help to merge two files. Any help or macro will be highly appreciated. I have two files. file A and file B. Need to update FILE A from File B. Each file has hundred of rows and about 50 column. If any word or phrase under column "Part" file A matches with any word under column "Part" file b

$$Excel-Macros$$ NSE Bhavcopy probelem

Hello Group, I am an analyst in the stock market, daily i download NSE bhavcopy and used to perform data analysis. For this purpose i have written a VBA code which automatically downloads bhavcopy from NSE site directly in excel. But i think from today NSE have change feature and changed file type

RE: $$Excel-Macros$$ excel help

Check to see if there is a SheetActivate event macro for that particular sheet. Regards - Dave. > Date: Tue, 1 Dec 2009 08:06:15 -0800 > Subject: $$Excel-Macros$$ excel help > From: karthikeyansankar...@gmail.com > To: excel-macros@googlegroups.com > > Hi, > > A particular sheet in excel file

Re: $$Excel-Macros$$ Not be able to upload d file on grup

Dear Manish, Just reply to this email, using that file as an attachment. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/1/09, Manish Pansari wrote: > > Hello all, > > I have one problem i

Re: $$Excel-Macros$$ excel help

Dear Karthik, Check if that sheet is protected. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/1/09, karthikeyan wrote: > > Hi, > > A particular sheet in excel file doesn't allow cut/copy

$$Excel-Macros$$ excel help

Hi, A particular sheet in excel file doesn't allow cut/copy/paste. txs -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2.

Re: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range class failed

I have tried recording it manually using a macro as Dave suggested and the code Deepak suggested with no luck. Here's the weird part, if the source is anything other than another Excel workbook, the past special code works fine. For example if I copy something out of Word, IE, Outlook, or even th

$$Excel-Macros$$ non excel query

hi can any one give me a macro for mail merge with attachment Thanks -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. E

$$Excel-Macros$$ Add brwose button to MS Excel to retrieve data from MS Access 2007

Hi Excel Gurus, Hope this new post find you all well. I would like to add a 'Browse button' (command button) to my excel 2007 file, which should pull the data from MS Access 2007. I hope its a bit confusing request, please do let me know if you need any further clarification. Regards--- -- --

$$Excel-Macros$$ Lookup hyperlink 300 times, copy and paste data from website, perform analysis in excel, and output findings to summary sheet

Hi I have limited understanding on using Macros. I have a workbook set up with 4 sheets: Sheet 1 - contains approx 300 hyperlinks to excel spreadsheets online, which I want to goto, copy all and paste to Sheet 2 - which simply contains raw data from 1 Sheet 3 - the analysis on raw data from 2 i

$$Excel-Macros$$ Formula Reference to ComboBox in User Form

Hi All, I have the following code which is supposed to select the activecell and then add a sumproduct formula to the value in the cell already. My problem is that the criteria for the sumproduct formula is taken from a combobox in a user form. ActiveCell.Select With ActiveCell .Formula = .Va

$$Excel-Macros$$ Not be able to upload d file on grup

Hello all, I have one problem in excel macro, but i m not be able to upload my file on our group. :( How i can move forward to solve my problem... .. My mail ID is pansari.man...@gmail.com, mail me if you want to help me out this proble . :) Thnxs, Manish -- ---

Re: $$Excel-Macros$$ Help

Thanks am working on your comments Hugs & Love On Mon, Nov 30, 2009 at 4:17 PM, Paul Schreiner wrote: > I have a few recommendataions for you. > > First: > You didn't mention which version of Excel you are using. > If it's Excel 97 (2003) then you have 6