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!
Bookmarks