Diminishing total

[roberj13]

I'm thinking I need a Macro for this . . .
I'm working on a log for permitts, these permits expire in 7 days, So I want to have a formula that takes the input from my daily sheet and have it copy to the corrisponding day with the colum called "days" ticking down to zero then removing the line from the 8th day sheet. I'm thinking it would be an if else loop somthing to the effect of IF(L3=i, i<8, i--) Else (delete), but I don't know how to translate that to Excel terms or where I would put it. See the attached file, thanks fellas

[NickyC]

Hi
to calculate whether the permit has expired you can use a formula such as:

Please Login or Register  to view this content.

in your daily sheet, where N3 is the expiry date

to delete rows where the permit is expired you will need a macro

this should work, assuming you have copied the formula above into column "L", and the cells with the copied formula begin in row 3:

Please Login or Register  to view this content.