Prev: if cell in other worksheet meets criteria, then leave blank.
Next: Conditional Formatting Minimim Value
From: Russell Dawson on 9 Apr 2010 14:10
You're welcome. Please tick Yes if I was helpful.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"jcheko" wrote:

> thanks for your help..for now I am going to use a button in my spreadheet
> linked to your macro..it is working well....I will still have to figure it
> out on the changes for the spreadsheet though...but for your time...very much
> appreciated.
>
> "Russell Dawson" wrote:
>
> > You might get what you want by searching the Help - input 2Track changes in a
> > shared workbook"
> >
> > I don't think yours is shared but it may help you.
> >
> > Good luck
> >
> > Cheers
> > --
> > Russell Dawson
> > Excel Student
> >
> > Please hit "Yes" if this post was helpful.
> >
> >
> > "jcheko" wrote:
> >
> > > your macro does work and it will put the date and time you included in the
> > > quotation signs that is cool, but it won't recognize if I modified the
> > > spreadsheet, all I am saying is that if between "range a5:s33" I changed
> > > something on it, the date should update, do you have another suggestion?
> > > thanks alot
> > >
> > >
> > >
> > > "Russell Dawson" wrote:
> > >
> > > > There's probably a really good way to do this.
> > > >
> > > > How about this macro. It uses the shortcuts for date Ctrl ; and for time
> > > > Ctrl/Shift ;
> > > > Activates by Ctrl S and includes a save. So, whenever you want to save the
> > > > changes enter Ctrl-S and the date and time will appear. Change cells to
> > > > suit. Format cells appropriately.
> > > >
> > > > Sub Macro1()
> > > > '
> > > > ' Macro1 Macro
> > > > '
> > > > ' Keyboard Shortcut: Ctrl+s
> > > > '
> > > > Range("A1").Select
> > > > ActiveCell.FormulaR1C1 = "4/9/2010"
> > > > Range("A2").Select
> > > > ActiveCell.FormulaR1C1 = "5:47:00 PM"
> > > > Range("A3").Select
> > > > ActiveWorkbook.Save
> > > > End Sub
> > > > --
> > > > Russell Dawson
> > > > Excel Student
> > > >
> > > > Please hit "Yes" if this post was helpful.
> > > >
> > > >
> > > > "jcheko" wrote:
> > > >
> > > > > I need to figure out a formula that returns the date when the spreadsheet was
> > > > > last modified. any changes number, letter, symbol...if I make any change I
> > > > > need the formula to return back the date teh spreadsheet was last
> > > > > modified...any
> > > > > help....thanks
From: Gord Dibben on 9 Apr 2010 18:44
Where do you want the modified date/time to be entered?

You can return that info to a cell or cells using event code.

Do you want it immediate or when you save or??

Can be done easily and automatically without hitting a button.

Tell us where you want the info displayed and when.


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 09:21:02 -0700, jcheko <jcheko(a)discussions.microsoft.com>
wrote:

>I need to figure out a formula that returns the date when the spreadsheet was
>last modified. any changes number, letter, symbol...if I make any change I
>need the formula to return back the date teh spreadsheet was last
>modified...any
>help....thanks

First  |  Prev  | 
Pages: 1 2
Prev: if cell in other worksheet meets criteria, then leave blank.
Next: Conditional Formatting Minimim Value