+ Reply to Thread
Results 1 to 6 of 6

Increasing the reference row in a series of random Formulas by one

  1. #1
    Registered User
    Join Date
    03-12-2004
    Location
    Harpenden
    Posts
    11

    Increasing the reference row in a series of random Formulas by one

    I have a main spreadsheet with about 100 rows where the individual cells contain links to a variety of different tables on different worksheets. I am creating a number of duplicate main spreadsheets but as I create them I want the link to go to one row lower than that in the original. Other than changing all the formulas manually is there anyway I can get the cells on the new sheet to point to a row lower than the main sheet?
    Ade

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Increasing the reference row in a series of random Formulas by one

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-12-2004
    Location
    Harpenden
    Posts
    11

    Re: Increasing the reference row in a series of random Formulas by one

    Hi Please see attached workbook which I have reduced in size as far as possible, removing all pivot tables and data sheets and just leaving the resultant tables which in the master workbook are more randomly set out
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,018

    Re: Increasing the reference row in a series of random Formulas by one

    1. Update your profile to show your current Excel verion. We NEED to know this to tailor our answers to your set up.

    2. Why are there sometimes gaps of 1 row between successive tables and at other times 2. Can this be FIXED at either 1 or 2... but not a random mixture?
    Glenn



  5. #5
    Registered User
    Join Date
    03-12-2004
    Location
    Harpenden
    Posts
    11

    Re: Increasing the reference row in a series of random Formulas by one

    Thanks for trying, its probably not worth the effort I will just do it manually.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,018

    Re: Increasing the reference row in a series of random Formulas by one

    I didn't do anything, because you never answered my question!!

+ 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. Cell Reference Increasing too much
    By Tillytong in forum Excel General
    Replies: 2
    Last Post: 04-02-2020, 02:12 PM
  2. [SOLVED] Random numbers increasing in value but summing to a specific total
    By JimDandy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2018, 09:46 AM
  3. [SOLVED] increasing a series of numbers
    By rajeshmarndi in forum Excel General
    Replies: 3
    Last Post: 04-15-2016, 12:09 PM
  4. Random Series of Numbers - Each series to have same GEOMEAN
    By nbezza in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-11-2013, 12:51 AM
  5. Increasing a cell reference
    By greiner524 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2012, 08:53 AM
  6. Increasing reference digits
    By jswarb001 in forum Excel General
    Replies: 2
    Last Post: 09-29-2010, 03:20 AM
  7. Increasing cell value based on random test
    By AndyGW in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-03-2010, 02:07 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