Need Column A and B to move with Column C when information is transferred to Column C

All info goes to the master inventory and then if some enters an amount for respray then it is transferred to the respray sheet. when it is transferred to the respray sheet it put the date in Column A and then put 3 days later in Column B.


Every day it will change and the date in A1 changes to tomorrow but if another item is enter as having resprays then it transfers to the respray sheet and will bump down in column C but Column A stays the in the same spot.


I need Column A and B to move up and down if something in Column C moves up or down and it would be nice to always have the oldest date at the top.

I feel like there needs to be a formula that I can have that can make the date in column A and b stay with Column C. Anybody have an idea? Does a date stamp only stay in that cell or does that move up and down if it is associated with Column C?

I need the date to move when Column C moves, is there anyway to do that.

Does anyone have a better formula for Column A that can be used? Need it to move up or down with column C.

Does a date stamp only stay in the cell or does that move up or down. Can I use a date stamp and have it tied somehow to the column C?