change cell content if sheetname is greater than a date on another sheet

[llnivy]

I have multiple daily sheets that are named by date starting at 01012019. I have another sheet that is named MovingLeaving. I am looking for a way to update one cell value on the daily sheets starting from a date on the MovingLeaving sheet and I need that value to update on every newsheet added that the name is greater than the date on the MovinLeaving sheet. I have a sample workbook but am not sure how to attach it.
Thanks in advance for the help!

 

[llnivy]

Anyone have any ideas on how I can accomplish this?

 

[My Aswer Is This]

Sorry to see you have not received a answer since March 29

But here are my questions:

1. Is This:

01012019

Month Day Year

Or Day Month Year

2. You said:

I am looking for a way to update ​

​

one cell value​

​

on the daily sheets ​

​

starting from a date on the MovingLeaving sheet​

​

and I need that value to update on every newsheet added that the name is greater than the date on the MovinLeaving sheet


You keep saying a cell but do not say what cell. Each sheet has millions and millions of cells
So how do we know what cell?

And how will we know when a new sheet is added?

We always need specific details like Range("B16")

Maybe with a few specific details we can help you.​

_{^{<strike>
</strike>}}​