+ Reply to Thread
Results 1 to 3 of 3

Short Cut for Duplicating the Tab

  1. #1
    Registered User
    Join Date
    12-27-2021
    Location
    Prague
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Post Short Cut for Duplicating the Tab

    Hi All,

    I don't really know how to ask this.

    But, everyday, I need to duplicate a new tab with a day+1-- Meaning 11/01/2022 12/01/2022 on the new tab. Is there any shortcuts of some way to do it faster smoother?


    Screenshot 2022-01-20 111002.png

    Thank you.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,721

    Re: Short Cut for Duplicating the Tab

    You could CTRL-drag the tab to the right to produce a copy, and then rename it.

    Is that what you mean?

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-27-2021
    Location
    Prague
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: Short Cut for Duplicating the Tab

    Hi Pete,

    Thank you for your answer, that is actually how I do it but as I need to do many of these in a row sometimes for 2 weeks. It takes still lots of time.

    I am trying to find some way, to make it faster. I tried to find some macro as well but I couldn't manage the formula to make it day+1 to tab name

    Thanks
    Raft

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I got Short snippet to Insert Row, is there a short snippet to drag UP range Row?
    By AndyJr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2017, 10:16 AM
  2. Help, Duplicating a sheet with duplicating ability
    By joseph_pat in forum Excel General
    Replies: 7
    Last Post: 06-26-2015, 07:55 AM
  3. Excel 2007 : The Formula is duplicating itself
    By srgtennis in forum Excel General
    Replies: 39
    Last Post: 03-22-2012, 12:15 PM
  4. Excel 2007 : Duplicating
    By Nemo26 in forum Excel General
    Replies: 1
    Last Post: 05-11-2010, 07:30 AM
  5. Duplicating ROWS
    By deportu in forum Excel General
    Replies: 4
    Last Post: 10-18-2009, 05:22 PM
  6. Duplicating
    By Latlong in forum Excel General
    Replies: 2
    Last Post: 10-13-2009, 01:16 PM
  7. [SOLVED] De-duplicating
    By Peter in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1