cell History

[Guest]

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

 

[Guest]

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

 

[Guest]

I tried to send it.It keeps being returned i`m sorry but I just dont know
what you mean how my data is layed out.I tried to explain it in my posts I
don`t know how else to explain it.I will try to resend it.

Thanks
Wayne

 

[Guest]

hi again,
fst0ne. the round think in the middle is the number zero not a capital
letter O.
try that.
regards
FSt1

 

[Guest]

fst1 I have tried the zero.It comes back saying you are not accepting mail.
from this client.So what am I missing in my posts I will try to explain it
for you.
Thanks
Wayne

 

[Guest]

hi,
I sent an email to myself at (e-mail address removed) and got it. what client are you
using?
You have showed me how one item in your enventory is layed out. were are the
rest?
and we have a small problem with the what it was and what it changed to
quantities. computer system that keep inventory histories use the previous
balance on the previous transaction as the what it was quantity. You may need
to set up a "start quantity" for each item you have. but this can be done
with macro also.

Regards
FSt1

 

[Guest]

Thanks.I will will put together the information and post today.I use
Sympatico also Hotmail.

Thanks again for your help

 

[Guest]

All Columns from B to S have the same row
numbers.

B8-B12 Right To S
B13-B17 "
B18-B22 "
B23-B27 "
B28-B32 "
B33-B37 "
B38-B42 "
B43-B47 "
B48-B52 "
B53-B57 "
B64-B68 "
B69-B73 "
B74-B78 "
B79-B83 "
B84-B88 "
B89-B93 "
B94-B98 "
B99-B103 "

My goal is to have all data in range
B8-B12 copied if any change is made to those cells
as it is 1 location.

Can the changes be copied to a different workbook

The above example shows where all my data is located.

Thanks
Wayne