+ Reply to Thread
Results 1 to 8 of 8

Help, Duplicating a sheet with duplicating ability

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    london
    MS-Off Ver
    2007
    Posts
    33

    Help, Duplicating a sheet with duplicating ability

    Hi,

    I have created a spreadsheet (sheet 1) which i would now like to duplicate (sheet 2) in the same workbook . That is the easy part,
    once it has been duplicated i want to use the = function so any changes made on sheet 1, also change on sheet 2 - that is also easy,

    the hard part is, sheet 1 is huge with thousands of fields, i do not have the time to to enter the formula =sheet1... into every field.
    Is there a way to duplicate the sheet 1 but also make it so that it will have the formula to duplicate each field from sheet 1 and if changes are made on sheet 1 the same changes will be made on sheet 2.

    Thankyou in advance to the expert that can assist.

    thankyou

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Help, Duplicating a sheet with duplicating ability

    What's the range you want to replicate on Sheet2?
    If posting code please use code tags, see here.

  3. #3
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Help, Duplicating a sheet with duplicating ability

    Sir if you need sheet in duplicate then why not you use share option.

  4. #4
    Registered User
    Join Date
    06-26-2015
    Location
    london
    MS-Off Ver
    2007
    Posts
    33

    Re: Help, Duplicating a sheet with duplicating ability

    The range is A to CA across
    and
    1 - 999 down

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Help, Duplicating a sheet with duplicating ability

    You could try this.

    Select A1:CA999, which you can easily do by typing the range in the name box.

    Type =Sheet1!A1 in the formula bar and confirm with CTRL+ENTER.

    With code.
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    06-26-2015
    Location
    london
    MS-Off Ver
    2007
    Posts
    33

    Re: Help, Duplicating a sheet with duplicating ability

    sorry not sure what you mean by share; to explain:
    sheet 1 is a basic view for ease of use, sheet 2 is more complex with more calculations.

  7. #7
    Registered User
    Join Date
    06-26-2015
    Location
    london
    MS-Off Ver
    2007
    Posts
    33

    Re: Help, Duplicating a sheet with duplicating ability

    Thankyou Norie, you are genius, once more require your help, all the boxes are populated with 0's - it has worked, how would i set it so that if the source box is empty, then nothing is displayed in the sheet 2 box (stays blank instead of showing 0)

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Help, Duplicating a sheet with duplicating ability

    Try this.
    Please Login or Register  to view this content.

+ 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. Duplicating data from one sheet to another
    By Jawnskeel in forum Excel General
    Replies: 5
    Last Post: 11-29-2012, 11:32 AM
  2. Duplicating Data on a different sheet
    By GraemeC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2008, 08:55 AM
  3. Auto duplicating a sheet
    By dvonj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2005, 09:06 PM
  4. RE: Auto duplicating a sheet
    By Jim Thomlinson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2005, 03:06 PM
  5. RE: Auto duplicating a sheet
    By dvonj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2005, 03:06 PM

Tags for this Thread

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