+ Reply to Thread
Results 1 to 3 of 3

Cut/Paste between sheets - how increase reference cell in formula

  1. #1
    Registered User
    Join Date
    09-15-2021
    Location
    Toronto, Canada
    MS-Off Ver
    365
    Posts
    2

    Cut/Paste between sheets - how increase reference cell in formula

    Newbie here

    I have a speadsheet for sport results
    The first 20 tab are the player and we list the score of that player. Each column is the skill they performed. Each line is the matches in the season
    the next 25 tabs are all the matches for the season. each line is a player, nd each column is a score for a specific skill

    In the player 1 tab, I then referenced Match1:B3 then Match1:C3 etc etc

    I want to create tab for player 2 -> 20, when I paste the content of tab 1 into tab2, I end up with match1:b3 and match2:c3, but I would like to get Match1:b4 and match2:c4 (because the 4th line in each match tab is the info about player 2)

    I attached a spreadsheet to show the issue

    thank you for any pointers you may have (doc, forum post (couldn't find a match) or article)

    Chris
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Cut/Paste between sheets - how increase reference cell in formula

    If you have 45+ tabs/sheets, that is probably already at least 40 too many. Excel works best when ALL data is stored on 1 sheet, and then a few other sheets perform analysis/extracts/summaries based on that 1 single data sheet
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-15-2021
    Location
    Toronto, Canada
    MS-Off Ver
    365
    Posts
    2

    Re: Cut/Paste between sheets - how increase reference cell in formula

    Hello,
    Great point
    Unfortunately I did not choose the design, I inherited it
    I managed to fix it by using the INDIRECT and building the formula based on a single cell in the sheet
    I added the new spreadsheet

    Chris
    Attached Files Attached Files

+ 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: 2
    Last Post: 05-08-2020, 08:04 AM
  2. drag horizontally a formula cell and increase the vertical reference
    By a_hatzidakis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-30-2017, 03:21 PM
  3. macro to increase a cell’s value based on a reference
    By wiggles8831 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2011, 03:50 PM
  4. Auto increase cell reference
    By GRAMMY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2011, 02:13 AM
  5. Replies: 3
    Last Post: 10-24-2006, 01:32 PM
  6. [SOLVED] how to paste formula but reference a fixed cell
    By HR in forum Excel General
    Replies: 3
    Last Post: 04-06-2006, 11:30 PM
  7. Text Cell reference and increase the cell reference by step value
    By Supriya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2005, 08:18 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