Forum Discussion
Worksheet tabs to include date from a cell
Hello ,
I have a worksheet with four tabs. Cell H1 in both tabs 1 and three contains a date. I would like to include that date in the tab name in the following format: for Tab 1 "AR - as of (the date in H1)" and for Tab 3 "AP - as of (the date in H1)". The dates in the tabs would update whenever the date in cell H1 is updated. I am using Microsoft 365 Apps for Enterprise, version 2510, Build 19328.20178. Thank you for your assistance.
3 Replies
- LorenzoSilver Contributor
Sample available at https://1drv.ms/x/c/1cd824d35610aacb/EeJgSJdWTeVFhWfPn_xLwa4BNFhpq2DXtj92XyZgkjnR_Q?e=IhPJOt (file to download - won't work with Excel Wed/Online)
NB: Not a VBA expert at all
- Harun24HRBronze Contributor
You will need to use VBA coding to achieve this.
- rbellmanCopper Contributor
I thought would be the case. Do you know what the VBA coding would be? Thank you!