View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Captain Ron Captain Ron is offline
external usenet poster
 
Posts: 1
Default 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