cell History
Hello:
I have a workbook that I want to track what was changed in a cell.My
information is laid out like this.The information has a boarder around it it
is called rack 1
A1 Product #
A2 Description
A3 Units
A4 Date
A5 Comments
What I want is if any cell in that range is changed it will record all the
information in the range to a seperate workbook called tracking.I use this to
track all shipping and receiving materials.The information that I would like
to record is:
Rack Spot
What it was
What it was changed to
When it was changed
Thanks for any help with this
Wayne
|