Thread: cell History
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wayne Wayne is offline
external usenet poster
 
Posts: 133
Default 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