Hi All,
Been a long time. Not sure if this is the right forum / section for this, but I'll attach my sample sheet and will try to post what I'm looking to do or if it's even viable with Excel.
The file is just for quick glance of pay rates at my company etc. I want to be able to select from the Drop Downs at the top (highlighted yellow - minus the HRS) the "Years with Company (yrs), Equipment type (Equip), Position (A or B), and Months (Mths: 1 - 12) and then have the cell(s) highlighted it corresponds to:
For example selecting: 06, AC 7, B, and 01
It would highlight in the first (green) table year 6 and AC 7 rate (in this case $6.00). I would like to see it highlight light yellow down and across and light red highlight the pinpointed cell.
I would also like it to calculate every cell / rate from 1 hour (which would be the default) to whatever number of hours is selected, plus also be able to multiply it by months selected (something like =rate*($I$1*24)*$k$1. I don't know if you need to have ghost cells with the default pay rates and have it reference them for the calculation (or the rate base to start the calculation...or if it can be done with the data in the cell already). In the end, basically, a person would be able to select the drop downs and pin point the plane, seat, and the rate for that year. They'd also be able to type hours of pay and see what they'd make, while also being able to see what they could make per 1 month all the way to 12.
Probably a lotta bit ambitious for my skill level, but really looking forward to suggestions and tips! Thanks!
Bookmarks