Log updates in second spreadsheet (with date stamp)

[shy07014]

Hey Guys,
This might seem like alot to ask but im kinda stuck, and im kind of a newbie, so if someone could help me out that would be greatly appreciated.

Here what i have:

(Sheet 1)
Column A: Item
Column B: Total In Stock
Column C: Total Out
Column D: Weight In Stock
Column E: Weight Out

And a button that on click: subtracts C from B, updates B, then clears C.
and, subtracts E from D, updates D, then clears E.

Please Login or Register  to view this content.

What i want to do:

Before i clear C and E, i want to copy all the data from any row that was changed, to Sheet 2 (in the next available row) and then add the date (pref. xx/xx/xxxx) to Column F (basically a log of every change)

thanx to all in advanced.