Changes Tracking VBA

[Lothrian]

Hi everyone,

I need some assistance. I'm still new to VBA, learning on the fly. I've been tasked with tracking updates to a sheet of data.

I don't know where to start.

The Task is to look at the LTQ Value and determine if it is different from the previously recorded value. If different add to the database of all projects and their scores.

Proj Id

Project Name

Project Owner Name

Proj Category

Mfg Location

Team

Line

Location

BU

Mfg Region

RR FTQ

RR LTQ

Date

Year

Completeion

Target

Month

xxx

xxx

xxx

xxx

xxx

xxx

xxx

xxx

xxx

xxx

100

100

xx/xx/xx

XX

C

80​

xx

How can I do this,

 

[Micron]

Not enough info. Where is the old value? Is it overwritten or appended? If overwritten, the value is in one spot; if appended, the last one has to be found. Then, what dictates the "last" one? Last in a column or row? Or not necessarily last in a list but last because it has the greatest date value associated with it?

add to the database

Add what, all that you've shown and the new value? Just the new value? This is all in Excel or the database is an Access db?
I imagine that the Change event for a sheet will be what triggers the comparison but that's another guess.