Prev: if cell in other worksheet meets criteria, then leave blank.
Next: Conditional Formatting Minimim Value
From: jcheko on 9 Apr 2010 12:21
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: Russell Dawson on 9 Apr 2010 12:53
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: jcheko on 9 Apr 2010 13:20
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: Russell Dawson on 9 Apr 2010 13:41
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: jcheko on 9 Apr 2010 14:02
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
 |  Next  |  Last
Pages: 1 2
Prev: if cell in other worksheet meets criteria, then leave blank.
Next: Conditional Formatting Minimim Value