A way to store item history

[zaibuojantis]

Hello I have a workbook where i keep my companies inventory, there I add items using tables/drop down lists. It would be ideal to track how long items have been used and have a simple history of their usage. Every item has its own serial number, title, rent owner name, site name where it's being used and price. When item is used i write start date, and when it ends its work I write an end date. I think that the best solution for me would be that when i write end date to a cell and hit enter, all cells with the items info (ex. A2:G2) would travel to another sheet where all of the history is stored. I have made a screenshot version of how it could look. Thank You! For Excelforum.png

[Mumps1]

It's difficult to work with a picture. Can you attach a copy of your workbook?

[zaibuojantis]

This is my inventory document, the history could be stored on the "Hist" sheet.

[Mumps1]

Place this code at the very beginning of your Worksheet_Change macro:

Please Login or Register  to view this content.

[zaibuojantis]

Place this code at the very beginning of your Worksheet_Change macro:

Please Login or Register  to view this content.

Thank you your code works perfect!

[Mumps1]

You are very welcome.