+ Reply to Thread
Results 1 to 2 of 2

How to create a dynamic copy of a sheet

  1. #1
    Registered User
    Join Date
    04-28-2020
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    27

    How to create a dynamic copy of a sheet

    Hi

    Suppose I have a excel file with one sheet ( sheet 1)

    I want to create a second sheet (sheet 2) which is a dynamic copy of sheet 1

    In other words, whatever I do in sheet 1 same things happens in sheet 2

    for example

    If I make cell A1 yellow in sheet 1............the cell A1 in sheet2 also becomes yellow
    If I enter a number in any cell of sheet1........same cell in sheet2 also show the number

    is it possible ?

    Thanks

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: How to create a dynamic copy of a sheet

    Copy and Paste the sheet and name it.

+ 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] Create new folder using active sheet's name
    By Raphaelp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2017, 05:48 PM
  2. Replies: 1
    Last Post: 01-04-2014, 06:37 PM
  3. How to copy the cells from one active sheet to another active sheet
    By pranav.y in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2013, 09:42 AM
  4. Replies: 1
    Last Post: 01-07-2013, 12:23 AM
  5. [SOLVED] Create a bouton to save as a pdf a another sheet then the active sheet using a custom name
    By sunny_island2002 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-14-2012, 08:01 PM
  6. [SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference
    By jm0392 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 07:12 PM
  7. Copy from active sheet and paste into new sheet using info from cell in active
    By Ingve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2006, 06:00 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