Nonebutshininghours
New Member
- Joined
- May 25, 2021
- Messages
- 2
- Office Version
- 2019
- Platform
- MacOS
- Web
My problem is a two parter!
I have an schedule that is laid out on one sheet. I plan on embedding the sheet to a website to have live on a screen for my employees to be able to see. The goal would be for them to see a range from 3 days before todays date through 21 days after todays date.
Here are my two questions:
1.)
The schedule is set up so that Row 4 (Starting with B:4) has sequential dates. We are constantly working on the schedule so embedding doesn't really work as if I'm working on the file I need to be able to be working on another months schedule without it changing what is viewed on the screen. So my question is can I make another sheet that contains the same data linked to my other sheet?
2.)
For The Sheet that I will embed, I want only want to show columns that are range from 3 days before todays date to 21 days after todays date. Can someone help me with the code for VBA?
I appreciate any help at all!
I have an schedule that is laid out on one sheet. I plan on embedding the sheet to a website to have live on a screen for my employees to be able to see. The goal would be for them to see a range from 3 days before todays date through 21 days after todays date.
Here are my two questions:
1.)
The schedule is set up so that Row 4 (Starting with B:4) has sequential dates. We are constantly working on the schedule so embedding doesn't really work as if I'm working on the file I need to be able to be working on another months schedule without it changing what is viewed on the screen. So my question is can I make another sheet that contains the same data linked to my other sheet?
2.)
For The Sheet that I will embed, I want only want to show columns that are range from 3 days before todays date to 21 days after todays date. Can someone help me with the code for VBA?
I appreciate any help at all!