On Apr 24, 1:45 pm, Captain Ron <Captain
wrote:
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

If the steps are numbered easily, like 1 2 3 4, and the columns in the
roster go in the same order, then you can easily use a VLOOKUP to do
this.