+ Reply to Thread
Results 1 to 4 of 4

Formula takes data from different cell on each Row

  1. #1
    Registered User
    Join Date
    03-08-2018
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    2

    Formula takes data from different cell on each Row

    Hi, I am quite new to Excel and have a simple problem.

    I have a workbook to record participants in a weekly bike ride.

    The top Rows contain details of each ride - date, route, distance, etc. Subsequent Rows contain details of the participants.

    Against each participant a cell contains the distance travelled, by reading the data in the cell at the top of the column.

    For the first participant say, this cell may be A5. If I copy the formula to the next Row, cell A5 becomes A6, and so on down the entire column.

    Please tell me how I can direct each row to read A5.

    I hope I have described this issue clearly, thanks for any help,

    Roger B
    Last edited by rogerbid; 03-09-2018 at 12:11 AM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    8,069

    Re: Formula takes data from different cell on each Row

    You need to use absolute references.

    $A$5
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    03-08-2018
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    2

    Re: Formula takes data from different cell on each Row

    Hello Jeffrey,

    Wow, as simple as that!!! Thanks so much for the super quick reply, very much appreciated

    Roger

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    8,069

    Re: SOLVED - Formula takes data from different cell on each Row

    Hi Roger,

    You are very welcome. Glad you now have a solution to help move your project along.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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