D
Dizzy
This may not be what you had in mind, but it's nice and
simple.
If you can you store Jul. data this way:
A2 = 852301.1 B2 = Left(A2,6)
Your Aug. file would only need:
A7 = 852301.2
B7 = VLookup(Left(A7,6),$B$2:$B$6,1,false)
Even better, store Jul. as:
A2 = Left(B2,6) B2 = 852301.1
and set up Aug. as follows: (gives the whole number)
A7 = 852301.2
B7 = VLookup(Left(A7,6),$A$2:$B$6,2,false)
simple.
If you can you store Jul. data this way:
A2 = 852301.1 B2 = Left(A2,6)
Your Aug. file would only need:
A7 = 852301.2
B7 = VLookup(Left(A7,6),$B$2:$B$6,1,false)
Even better, store Jul. as:
A2 = Left(B2,6) B2 = 852301.1
and set up Aug. as follows: (gives the whole number)
A7 = 852301.2
B7 = VLookup(Left(A7,6),$A$2:$B$6,2,false)