VBA Tips - Track Changes By Adding A Time Stamp

Hello,

I have number of Worksheets within an Excel Workbook that are linked to an Access database query. I have a command button on each of these Worksheets that, when clicked, runs a simple macro which refreshes the data.

I would like to add a time stamp to one of the empty Cells on these Worksheets, which would reflect the last time the data was refreshed.

Can anyone offer a suggestion as to how I could code this, please? I would most likely add it to the macro I already have that refreshed the data.

Thanks,

Matty

I have column a2 thru a20 where I add data. I want column b2 to b20 to automatically enter the date and time I entered the data in column a2,a3,.... I am using the the following formula in column b: =IF(A2>0,NOW(),IF(A2=0,"")). It work okay when I enter data in a2 The date and time is automatically entered in b2, but when I add new data at a much later time in a3 the time changes in b2 with the date and time that is auto entered in b3 when the new data was entered. How do I overcome this?
Thanks in advance.
Alex

Good folk,

I am coming along, slowly but surely, with my Excel VBA and formulas, but I cannot seem to come up with good ideas on making a sharp-looking spreadsheet: it all looks too terribly crude, rudimentary, amateurish.

Does anyone know of sites, books or tips on putting a polish on? I'm not looking for an application or anything like that, that will do it for me: I'm convinced that, if I get a little inspiration, I can take it from there.

Hope you can help.

Thanks,



Derek

Is it possible to add tooltips or helper tips to my custom fucntions so the
user knwos what parameters need to be entered to use my fucntion? I'm
currnetly using VBA but could use another lanuage (c#, VB) if that would help.

Thanks,

Hi,

I am trying to have Excel automatically put a time/date stamp in a cell anytime a worksheet (not a workbook) has been changed.

I have seen the code for an automatic time/date stamp right before a workbook is saved, but I am looking for something that will do this anytime a worksheet is changed.

Any tips are appreciated.

Thanks!

Hello, I have searched and not come up with anything I can modify for my purpose. I have a specific cell "B321" that has a formula and changes regularly throughout the day based on entries elsewhere within the workbook. This cell value can change as many as 250 times from open to close. My goal is to have a seperate worksheet (hidden) named "timestamp info" collect in column "A" the value of B321 when it initially changes from "" and column "B" would show actual time this event occured. Columns A & B would continue to collect this info each time B321 changes.

Many Thanks

Hi,

I've used a circ ref formula to create a time stamp for 'time in' column when data is entered into 'attendant' column. This would help to minimise input errors.
....this works fine but has messed up calculations for 'time elapsed' and 'downtime' columns.
Calculations in these columns work fine if I remove the circ formula and input time manually

Thanks...

I have more audio tracks than I can burn onto an audio CD. I can manually parse the audio files into playlists or directories (one playlist/directory for each audio CD) if I can just add up the track times of all the tracks in my input stream.

I have all the tracks listed with their track times in a two column spreadsheet. I just need to add up the times column so carries from seconds roll to minutes and carries from minutes roll to hours. It would be very nice if, when the total would exceed 1 hour and 10 minutes (the capacity f an audio CD) , the count would start over making it very obvious where I need to break the nput into another 'chunk'.

Suggestions?

Greetings all, VBA/macro newbie/dummy here! I have a fair amount of time studies to run in the near future, and in the interest of being lazy I'd like a macro to insert the time into the active cell using a hotkey rather than manually entering the data, as the events to be recorded occur a few times a minute. Any assistance would be greatly appreciated! Thanks & take care.

Hi all,


I've used the =NOW() function but it applies only to any changes in the whole document.

WHat if I want to to know the time a guest arrived every time I "marked"the attence in excel? I would like to preserve the arrival time of all guest.

Does anyone knows how?

Thanks