I have numbers in "column B"
there is a date in "column J"
is it possible to make the number in "B" auto repeat back into column "B" but with the date in column "J"?
I hope I'm making sense.
I'm hoping this can be done without VBA, but if I don't have a choice, then VBA is ok I guess.
Thank you
there is a date in "column J"
is it possible to make the number in "B" auto repeat back into column "B" but with the date in column "J"?
I hope I'm making sense.
I'm hoping this can be done without VBA, but if I don't have a choice, then VBA is ok I guess.
Thank you
schedule 4 tracker.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
3 | Date | Unit | Oil | WMA | Other | Other2 | Scheduled Date | Start Date | End Date | Expired Date | ||
4 | 1-Jan-24 | 8545 | 1-Jan-24 | 31-Jan-24 | ||||||||
5 | 2654 | 1-Jan-24 | 31-Jan-24 | |||||||||
6 | 8564 | 1-Jan-24 | 31-Jan-24 | |||||||||
7 | 3695 | 1-Jan-24 | 31-Jan-24 | |||||||||
8 | 7458 | 1-Jan-24 | 31-Jan-24 | |||||||||
9 | 7485 | 1-Jan-24 | 31-Jan-24 | |||||||||
10 | 5245 | 1-Jan-24 | 31-Jan-24 | |||||||||
11 | 1564 | 1-Jan-24 | 31-Jan-24 | |||||||||
12 | 9565 | 1-Jan-24 | 31-Jan-24 | |||||||||
13 | 6656 | 1-Jan-24 | 31-Jan-24 | |||||||||
14 | 2136 | 1-Jan-24 | 31-Jan-24 | |||||||||
15 | 3256 | 1-Jan-24 | 31-Jan-24 | |||||||||
16 | 2154 | 1-Jan-24 | 31-Jan-24 | |||||||||
17 | 3416 | 1-Jan-24 | 31-Jan-24 | |||||||||
18 | 8461 | 1-Jan-24 | 31-Jan-24 | |||||||||
Master |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G4 | G4 | =A4 |
G5 | G5 | =A4 |
G6 | G6 | =A4 |
G7 | G7 | =A4 |
G8 | G8 | =A4 |
G9 | G9 | =A4 |
G10 | G10 | =A4 |
G11 | G11 | =A4 |
G12 | G12 | =A4 |
G13 | G13 | =A4 |
G14 | G14 | =A4 |
G15 | G15 | =A4 |
G16 | G16 | =A4 |
G17 | G17 | =A4 |
G18 | G18 | =A4 |
J4:J18 | J4 | =[@[Scheduled Date]]+30 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
C18:F31 | Other Type | Icon set | NO | |
C4:F17 | Other Type | Icon set | NO | |
A4:A5493 | Expression | =($L$2=A4) | text | NO |
B4:B5493 | Expression | =AND($L$2=G4, (ISBLANK(I4))) | text | NO |
B4:B5493 | Expression | =AND($L$2>G4, (ISBLANK(I4))) | text | NO |
B4:B5493 | Expression | =AND($L$2>G4, NOT(ISBLANK(I4))) | text | NO |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
B3 | Any value | |
F3 | Any value | |
G3 | Any value | |
H3 | Any value | |
I3:J3 | Any value |