Forum Discussion

rbellman's avatar
rbellman
Copper Contributor
Nov 12, 2025

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

  • Lorenzo's avatar
    Lorenzo
    Silver 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

    • rbellman's avatar
      rbellman
      Copper Contributor

      I thought would be the case.  Do you know what the VBA coding would be?  Thank you!

Resources