Logging

[sk2613]

Hi everyone,

Firstly, I'd like to apologize if something of this sort has been posted, but I am not very familiar with VBA and wasn't able to use the code on this site to build what I need. So any assistance is much appreciated.

So here is an attached spreadsheet of what I would like to final product to be like.

Everytime a new sale is made on sheet "Sales", I would like to have the total sales recorded onto the sheet "Log" as well as the timestamp of when that total was changed/calculated.

Any assistance would be great.

Thanks all,

Sang

[royUK]

Something like

Please Login or Register  to view this content.

[sk2613]

thanks roy,

got it to work.

[sk2613]

i've got another question on this...

instead of having the log track after each record is changed, is there a way to log the record only when the save function is used, such as when save via file-> save or keyboard shortcut save triggers the code to only log/track the number.

thanks.

[SOS]

sk2613,

Put the same code inside a Workbook_Before Save module

Please Login or Register  to view this content.