+ Reply to Thread
Results 1 to 2 of 2

Reference data in successive rows in each new sheet?

  1. #1
    Registered User
    Join Date
    08-16-2017
    Location
    london
    MS-Off Ver
    2016
    Posts
    1

    Reference data in successive rows in each new sheet?

    Can anybody suggest a formula/solution which would allow me to reference the data in each row individually as I progressively create a new sheet?

    I.e If the master sheet containing the rows of data are on Sheet1. I would like Cell A1 in Sheet2 to reference the information in 'Sheet1!A1'.

    But then when I create Sheet2, I would like cell A1 to reference the data in 'Sheet1!A2'.

    A1 on Sheet3 = 'Sheet1!A3'
    A1 on Sheet4 = 'Sheet1!A4'

    And so on...

    is there a formula that can be inserted into cell A1 so that when I copy the previous sheet it will reference the next row of data on the master sheet Sheet1?

    Hope that makes sense.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Reference data in successive rows in each new sheet?

    What is the use of that action. What would be the further actions on that mastersheet?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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: 1
    Last Post: 05-12-2017, 02:53 AM
  2. [SOLVED] Increase value in quotation marks in successive rows
    By alexuk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2017, 12:52 PM
  3. Log User Input In Successive Rows
    By Vergewaltiger in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-06-2014, 03:21 PM
  4. [SOLVED] Select Successive Rows
    By Floydlevedale in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-09-2012, 03:48 AM
  5. Replies: 1
    Last Post: 06-23-2012, 03:40 PM
  6. Macro to add data to successive rows of a table
    By gigiw1986 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-25-2010, 05:20 PM
  7. [SOLVED] formula to apply concatenation to successive rows of data
    By Devo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2006, 12:45 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