How to detect amount of changes in cell?

Originally Posted by TMShucks

You could use a Worksheet_Change event to monitor the cell and record the changes on a hidden worksheet in the workbook.

You could store both the date and the cell change count so that you can reinitialize daily.

Needs some thought but it's do-able

Regards

Ill give you a visual example of what i'm trying to do

Say i have 100 pens, 200 pencils, 300 rulers...

They all get taken on a daily basis, I want to create a data sheet that if for example my outflow of pens is very high per day, then i want it to be highlighted.

Also i want see how much material is being given out per week, per month so i would know how much of what i need to purchase to keep my stock on a safe level i.e. i wont be running out pf materials all of a sudden

So i need to check how much of that particular material is being withdrawn + if it is being withdrawn in batches i.e. is there a pen with drawn once a day 5 pens once a day etc., i hope this clarifies it slightly?

Let me know if you need any more info...

Again i just came with this today so it all up in the air

P.S. its a change tracking system

ill have a look at the Worksheet_Change event...

Originally Posted by royUK

Perhaps storing as a Name would be best, then it should be less likely to be deleted accidentally

Please Login or Register  to view this content.

I take it this code changes the cells name? doesn't change for me for some reason...
I was thinking maybe to create an auto comment?
The thing is if i want to graph the data later on i will have to extract it further. Having it stored in a spare sheet is much easier.

So as mentioned above, if i have a macro that can date how much of the particular material has been withdrawn i would be able to sum then and have my monthly and yearly figures

Something like this maybe?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Please Login or Register  to view this content.