software

I have information from another source and it is downloaded into excel every
week, In my Employee excel spreadsheet, I have emp that have pay grades,
increment steps and salary that goes with that step. On my evaluation form I
want excel to look at what the employee increment step is now - change it to
the next increment step and replace the salary with the new salary that goes
with that increment step. I want to know the best way to do this. Should I
have a source sheet with Increment in one cell - Salary in another cell and
then create a vlookup formula? The only problem I have is getting excel to
know to change the increment step. Thanks,

If increment steps were identified by column headings, then given current
increment step, move to next column; but as you say, you need to record
current increment somewhere. How is the data organised - can you post an
example?

quot;Pam Cquot; wrote:

gt; I have information from another source and it is downloaded into excel every
gt; week, In my Employee excel spreadsheet, I have emp that have pay grades,
gt; increment steps and salary that goes with that step. On my evaluation form I
gt; want excel to look at what the employee increment step is now - change it to
gt; the next increment step and replace the salary with the new salary that goes
gt; with that increment step. I want to know the best way to do this. Should I
gt; have a source sheet with Increment in one cell - Salary in another cell and
gt; then create a vlookup formula? The only problem I have is getting excel to
gt; know to change the increment step. Thanks,