Hi,
I have 2 Sheets in workbook. Product and cost listed in one sheet and the history of changes in another sheet.
I want to automate the process. Each time the cost changes in product sheet, the product name, cost and timestamp should get written in History sheet.
The changes in cost happens in 30 minutes at the least, usually in few hours.
I will be grateful, If someone help me with the solution.
Thank you in advance
Nadeem
I have 2 Sheets in workbook. Product and cost listed in one sheet and the history of changes in another sheet.
I want to automate the process. Each time the cost changes in product sheet, the product name, cost and timestamp should get written in History sheet.
The changes in cost happens in 30 minutes at the least, usually in few hours.
I will be grateful, If someone help me with the solution.
Thank you in advance
Nadeem