Saved By and Date...

London2008

New Member
Joined
Sep 16, 2008
Messages
3
Hi there<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
I have 'lots' of workbooks that are constantly being updated by various people. Over the top of these workbooks I have one summary spreadsheet that pulls data from the workbooks and has two fields that should state who last saved the various workbooks and when it was saved to enable me to monitor who has been updating their forecasts.<o:p></o:p>
<o:p></o:p>
I was going to do the date by '=NOW()' in each workbook and link it back to the summary workbook, but i can't work out how to do the user... and not sure =NOW() is the best why to do the date either.<o:p></o:p>
<o:p></o:p>
Any suggestions?<o:p></o:p>
<o:p></o:p>
Thanks in advance

M<o:p></o:p>
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Makrini

Well-known Member
Joined
May 22, 2007
Messages
1,035
You could create this UDF

Code:
Function theuser()
    theuser = Environ("username")
End Function
then put in a cell.. =theuser() & " " & Now()
 

Watch MrExcel Video

Forum statistics

Threads
1,095,205
Messages
5,443,025
Members
405,212
Latest member
Arnie58

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top