adding and taking away

[B4L4KS]

how can i create a formula that when a cell equals 1 other cells drop by one
and the same for two but the formula needs to add on continuously

also reset itself once a day

kristian

 

[MrKowz]

Can you please provide an example of what you want? Are you wanting it to reset the first time you load the spreadsheet each day?

 

[B4L4KS]

hi

i need it so it resets once a day,

preferably at the end of the day

thanks

 

[MrKowz]

What defines the "end of the day"? Where do you want these cells located in your spreadsheet? I need more details.

 

[B4L4KS]

start of the day 11am
end of the day 12pm midnight

thanks

kristian

 

[MrKowz]

In the formula:

=COUNTIF(Recept!L16,'Order Form'!H12:I12)*'Order Form'!K12

What cell are you changing to update the value of H11? I'm thinking that we need to have a Worksheet_Change event monitor for the change of that cell you manually adjust so that when you do change it, it will adjust the values in column I.

Also, I might reccomend that the worksheet be "reset" when it is first opened in the morning (unless the worksheet will be open at midnight every night).​