+ Reply to Thread
Results 1 to 4 of 4

Copying Sheet 1 to multiple sheets

  1. #1
    Registered User
    Join Date
    09-17-2019
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    11

    Question Copying Sheet 1 to multiple sheets

    Good evening,
    this is my second post. I hope I explain myself correctly.
    Sheet 1 Contains no data but formulas
    I know how to copy sheet 1 to sheet 2, the problem is that the formulas continue referring to sheet one.

    Example:
    Sheet 1 Cell C2 Formula is
    HTML Code: 
    =SUM(Exam1!B2/Exam1!H4)*100
    On sheet 2 the formula should be
    HTML Code: 
    =SUM(Exam2!B2/Exam2!H4)*100
    but its not, its still
    HTML Code: 
    =SUM(Exam1!B2/Exam1!H4)*100
    So whatever goes into sheet 1 will go into every consequent sheet, whereas i need every sheet to be independant.

    I need to do this copy/paste about 30 times, so having to manually edit every sheet would be
    a pain.
    The last sheet would be for example;
    HTML Code: 
    =SUM(Exam30!B2/Exam30!H4)*100
    Can anyone help with the copy paste problem please

    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
    21,261

    Re: Copying Sheet 1 to multiple sheets

    You could use Find&Replace (CTRL-H) on your second sheet to change Exam1 to Exam2 for all formulae in one operation, then repeat for your other sheets.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    09-17-2019
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    11

    Thumbs up Re: Copying Sheet 1 to multiple sheets

    Hi Pete,
    Thanks, I've tried it and it works, just a shame i have to do it 30 times, thanks for the help.

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

    Re: Copying Sheet 1 to multiple sheets

    You're welcome, and thanks for the rep.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Pete

+ 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. Multiple Sheets, copying/summing from one sheet to another
    By SandeA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2019, 03:43 PM
  2. Replies: 1
    Last Post: 01-11-2018, 12:59 AM
  3. Copying data from multiple sheets to one sheet
    By aparnawangu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-22-2017, 05:53 AM
  4. Copying columns from multiple sheets into one sheet
    By priyankalaha18 in forum Excel General
    Replies: 5
    Last Post: 08-01-2017, 09:54 AM
  5. Replies: 3
    Last Post: 06-20-2014, 05:49 AM
  6. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:29 PM
  7. Copying cells from 1 sheet to multiple sheets
    By stevenwhite1968 in forum Excel General
    Replies: 3
    Last Post: 05-10-2011, 09:49 AM

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