Hi All,

I have created a spreadsheet to track materials as to qty, location and other information needed.
Sometimes these materials have to be used for one job, returned and sent to another site.

What i'm chasing is a way to log in a separate sheet all the changes that have happened to each Drum# (Identifier) so that i know where they have been previously.

E.g. - If A-001 needs to be sent to site, I will change LOC & BIN accordingly. If it was to return with less qty, i would then update the cells accordingly. I would need for the Log to show that it has gone to site, and came back from site with the different qty and LOC etc.

Hopefully i have explained this well enough.
Attached is a sample of the sheet i have created, I currently have almost 2000 Drum# on this sheet.
I'm happy to use VBA with this, as i'm sure it will be required for such a thing.

Regards,
Bam
DrumsEG.JPG