How to auto update a cell with a current date

G

Guest

I have a spreadsheet which is tracking office issues and has multiple rows.
What I am looking for is a way to have a cell auto update with the current
date and time when I update any cell within that row.

I know that I can use the Today() function - however this updates the entire
spreadsheet when it is opened. I am looking to only update the date in a
particular row - if I have made a change to another cell in that row.

Thanks for your help!!!!
 
G

Guest

I'm guessing you'll have to do this with VBA. I'd look at the
Worksheet_Change event macros first. Maybe someone else can give more info
 
G

Guest

Hi Kell,

did you try copy and paste special values for the dates before today?

use the today() function and before close the wb, copy and paste special

HTH
Regards from Brazil
Marcelo


"Kell2604" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto update date 5
Auto Stamp Date 13
How To Have A Cell Be Blank If... 2
if/then insert date but don't want automatic updates 7
Formula to auto-populate with current date 1
update date 2
Add Date 2
update Totals using current date 1

Top