Omkar Balgobin
New Member
- Joined
- Sep 27, 2017
- Messages
- 2
[h=2]Log Files within an Workbook to track changes[/h]
Hi,
I created a quotation template for a small business, I would like to create a log work sheet so that I can track or keep a count of all the quotes that was done.
Eg.
Lets say the Quote # is in Cell A1 and the Customer is stored in Cell B2 and the Value is Stored on C3. For every time a quote is Save/ SaveAs the information is stored in a worksheet, this process continues to log/ save the Quote #, Customer & Value in the log worksheet every time someone Save/SaveAs a quotation.
The information in the worksheet will be stored as follows Column A,B,C Rows 1,2,3,4,5,6,7 etc.
Any assistance would be greatly appreciated.
Regards,
OB
I created a quotation template for a small business, I would like to create a log work sheet so that I can track or keep a count of all the quotes that was done.
Eg.
Lets say the Quote # is in Cell A1 and the Customer is stored in Cell B2 and the Value is Stored on C3. For every time a quote is Save/ SaveAs the information is stored in a worksheet, this process continues to log/ save the Quote #, Customer & Value in the log worksheet every time someone Save/SaveAs a quotation.
The information in the worksheet will be stored as follows Column A,B,C Rows 1,2,3,4,5,6,7 etc.
Any assistance would be greatly appreciated.
Regards,
OB
