Forum Discussion
rbellman
Nov 12, 2025Copper Contributor
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.
1 Reply
- Harun24HRBronze Contributor
You will need to use VBA coding to achieve this.