+ Reply to Thread
Results 1 to 5 of 5

moving a cell reference down one row automatically

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    Centralia, IL
    MS-Off Ver
    2013
    Posts
    3

    Question moving a cell reference down one row automatically

    I am trying to develop a spreadsheet that will replace a salary schedule program we used to have. I have a listing of each employee with 4 columns...NAME, DEGREE, ADDITIONAL HOURS, and YEAR'S EXPERIENCE. The 5th column is SALARY and each employee (row) has a corresponding cell reference from an associated worksheet that inserts their salary based on the listed criteria above. Each year, the employees gain a years experience and therefore advance one year (row) down on the salary schedule. I know how to increase each year by one in the YEARS column by using a special paste and adding 1 under operations. However, I can't figure out how to automatically advance each employee down one row on the salary table.

    Is there a function or formula that will change each cell reference in a colomn by one row? For example: A2 would change to A3, D6 would change to D7, F12 would change to F13. I can do it manually but would prefer an easier way!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: moving a cell reference down one row automatically

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    07-17-2014
    Location
    Centralia, IL
    MS-Off Ver
    2013
    Posts
    3

    Re: moving a cell reference down one row automatically

    Here is the file you requested. Hope my instructions are clear in what I am trying to accomplish!
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: moving a cell reference down one row automatically

    Please see attached.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-17-2014
    Location
    Centralia, IL
    MS-Off Ver
    2013
    Posts
    3

    Re: moving a cell reference down one row automatically

    Thank you so much!!!! I knew there had to be a way. I researched it and had a feeling it was a LOOKUP function, but I have only used LOOKUP in one column or one row. I wasn't sure how to use it for an entire table. You have saved me so much work. :D

+ 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. Automatically Moving the Cursor to Next Cell
    By sathishkm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2014, 01:25 AM
  2. [SOLVED] Moving data to another cell automatically.
    By Krix in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-23-2013, 12:04 PM
  3. Moving automatically from one cell to another
    By sfar007 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-08-2006, 01:31 PM
  4. Moving to a different cell automatically.
    By Fernandoalberte in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-12-2005, 03:25 PM
  5. [SOLVED] moving cell contents (automatically)
    By Rusty in forum Excel General
    Replies: 1
    Last Post: 06-15-2005, 04:05 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