+ Reply to Thread
Results 1 to 5 of 5

Copy multiple worksheets with cell reference to to original worksheets in same workbook

  1. #1
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    126

    Copy multiple worksheets with cell reference to to original worksheets in same workbook

    Hi -

    I want to Copy 3 worksheets i.e. A, B & C multiple time (count defined in "Summary" worksheet cell H6).
    In Original B has formula that takes data from A and similarly C has formula that takes data from A.
    Similarly when the B_New file is copied it should take data from A_New but no A.

    Please check the macro I am using and suggest any correction.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by santanuKD; 06-07-2019 at 03:46 AM.
    Shan

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Copy multiple worksheets with cell reference to to original worksheets in same workboo

    Code tags added by OP
    Last edited by Pepe Le Mokko; 06-07-2019 at 03:49 AM.

  3. #3
    Forum Contributor
    Join Date
    06-12-2009
    Location
    Banglore
    MS-Off Ver
    Excel 2007
    Posts
    126

    Re: Copy multiple worksheets with cell reference to to original worksheets in same workboo

    Done Will follow the same in future.
    Last edited by santanuKD; 06-07-2019 at 03:53 AM.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Copy multiple worksheets with cell reference to to original worksheets in same workboo

    Thanks
    and BTW, do not quote entire posts unnecessarily. They are just clutter and make the thread hard to read.
    Use the " Quick Reply" button instead.
    Thanks

  5. #5
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    Re: Copy multiple worksheets with cell reference to to original worksheets in same workboo

    just an fyi, where is this sheet in the workbook?

    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. Replies: 0
    Last Post: 08-07-2015, 08:44 PM
  2. [SOLVED] Copying Formulas Between Worksheets While Keeping Reference to Original Worksheet
    By PandaBear2014 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2014, 06:32 PM
  3. Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets
    By NumberCruncher311 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2013, 08:21 PM
  4. [SOLVED] Copy of 1 cell into multiple worksheets in the same workbook
    By Service1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2012, 12:19 AM
  5. Copy of 1 cell into multiple worksheets in the same workbook
    By Service1 in forum Access Tables & Databases
    Replies: 2
    Last Post: 08-09-2012, 10:25 AM

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