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

llnivy

New Member
Joined
Aug 1, 2018
Messages
3
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!
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
Office Version
2013
Platform
Windows
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>
 

Watch MrExcel Video

Forum statistics

Threads
1,095,970
Messages
5,447,595
Members
405,459
Latest member
newbie111

This Week's Hot Topics

Top