hi Wayne,
FSt1 here. I thought we talked about this back on the 25th. you never
emailed me your file. i'll help if i can but you have to let me know how your
data is layed out. go back to the other posts we did and review.

Regards
FSt1

"Wayne" wrote:

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