Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to use data from another worksheet
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to use data from another worksheet
Thanks for responding Spiky. Let me try to explain further.
Worksheet 1 A B C D 1 Name Grade Step Wage 2 Blow, Joe Firefighter 3 ???? 3 Schmo, Joe Captain 1 ???? 4 Whoa, Joe Major 2 ???? Worksheet that wage info will come from A B C D E 1 Grade Step1 Step2 Step3 Step4 2 Firefighter 10.00 11.00 12.00 13.00 3 Sergeant 14.00 15.00 16.00 17.00 4 Captain 18.00 19.00 20.00 5 Major 21.00 22.00 23.00 So will VLOOKUP work to get cell D1 in worksheet 2 to cell D2 in WS#1 cell B4 in WS #2 to cell D3 in WS#1 cell C5 in WS #2 to cell D4 in WS#1 Thanks for your help "Spiky" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to use data from another worksheet
On Apr 24, 9:42 pm, Captain Ron
wrote: Thanks for responding Spiky. Let me try to explain further. Worksheet 1 A B C D 1 Name Grade Step Wage 2 Blow, Joe Firefighter 3 ???? 3 Schmo, Joe Captain 1 ???? 4 Whoa, Joe Major 2 ???? Worksheet that wage info will come from A B C D E 1 Grade Step1 Step2 Step3 Step4 2 Firefighter 10.00 11.00 12.00 13.00 3 Sergeant 14.00 15.00 16.00 17.00 4 Captain 18.00 19.00 20.00 5 Major 21.00 22.00 23.00 So will VLOOKUP work to get cell D1 in worksheet 2 to cell D2 in WS#1 cell B4 in WS #2 to cell D3 in WS#1 cell C5 in WS #2 to cell D4 in WS#1 Thanks for your help This should work, copied into column D on WS#1: =VLOOKUP(B2,'WS#2'!$B$1:$E$5,C2+1) You'll have to adjust the range to fit your source database. And make sure your grades are all typed perfectly on both sheets. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to use data from another worksheet
Thanks Spiky. Greatly appreciate your time! "Spiky" wrote: On Apr 24, 9:42 pm, Captain Ron wrote: Thanks for responding Spiky. Let me try to explain further. Worksheet 1 A B C D 1 Name Grade Step Wage 2 Blow, Joe Firefighter 3 ???? 3 Schmo, Joe Captain 1 ???? 4 Whoa, Joe Major 2 ???? Worksheet that wage info will come from A B C D E 1 Grade Step1 Step2 Step3 Step4 2 Firefighter 10.00 11.00 12.00 13.00 3 Sergeant 14.00 15.00 16.00 17.00 4 Captain 18.00 19.00 20.00 5 Major 21.00 22.00 23.00 So will VLOOKUP work to get cell D1 in worksheet 2 to cell D2 in WS#1 cell B4 in WS #2 to cell D3 in WS#1 cell C5 in WS #2 to cell D4 in WS#1 Thanks for your help This should work, copied into column D on WS#1: =VLOOKUP(B2,'WS#2'!$B$1:$E$5,C2+1) You'll have to adjust the range to fit your source database. And make sure your grades are all typed perfectly on both sheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link variable data from one worksheet to another worksheet? | New Users to Excel | |||
Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
Using a column of data from 1 worksheet to extract data from another worksheet | Excel Worksheet Functions | |||
how do i maintain one worksheet from data from multiple worksheet | Excel Worksheet Functions | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions |