nniedzielski
Well-known Member
- Joined
- Jan 8, 2016
- Messages
- 598
- Office Version
- 2019
- Platform
- Windows
I have two workbooks that are communicating with each other,
One workbook is used by a clerk and has data entered intoit, the other work book is displayed on a monitor outside of the office.
I am trying to get the two workbooks to talk to each otherso the clerk doesn’t have to pull the display sheet in each time there is data.
I created a formula to get the two sheets to talk, but thisneeds to happen for each day of the month, as each workbook has a tab for days1-31.
This is the formula being used:
What I need is to be able to create a template for the sheetwhere the “DEC” in the formula will change from month to month,
How can I get the formula to change from JAN to FEB and soforth as the months change?
One workbook is used by a clerk and has data entered intoit, the other work book is displayed on a monitor outside of the office.
I am trying to get the two workbooks to talk to each otherso the clerk doesn’t have to pull the display sheet in each time there is data.
I created a formula to get the two sheets to talk, but thisneeds to happen for each day of the month, as each workbook has a tab for days1-31.
This is the formula being used:
Code:
='[1st Shift Creation Macro.xlsm]DEC1'!$E4
What I need is to be able to create a template for the sheetwhere the “DEC” in the formula will change from month to month,
How can I get the formula to change from JAN to FEB and soforth as the months change?