Trying to use data from another worksheet
I'm trying to have excel automatically input data from a worksheet into
specific cells on another worksheet. To better explain:
I have a pay plan that consists of Grades (rows) and Steps (columns)
There are 9 different pay grades (ranks) with either 3, 4, or 5 steps in them.
I have another worksheet that lists our firefighters alphabetically and
contains their pay grade and step in a column.
I want excel to transfer the hourly wage from the pay plan to the
alphabetical roster worksheet based on the pay grade and step listed in
alphabetical worksheet.
Any help????
Thanks
|