D
DolittleDustoff
Working with two worksheets within one workbook. Sheet one is th
calculation sheet, the other is the data sheet which the data is use
in the calculations. I'm creating a weight and balance worksheet fo
our fleet of helicopters.
On the data sheet I have a list of tail numbers and their relate
weight, arm number, and another arm number. I've successfully made
drop-down list on the calculation sheet from the tail numbers on th
data sheet.
My problem is I want the weight, arm number, and the other arm numbe
to go into there proper cell location in the calculation sheet when
select the tail number from the drop-down list. I would also like thi
to happen when I should select a different tail number from th
drop-down list.
Any Help would be grateful. I can fly a helicopter but I crash an
burn with excel.
Thanks
DolittleDustoff:
calculation sheet, the other is the data sheet which the data is use
in the calculations. I'm creating a weight and balance worksheet fo
our fleet of helicopters.
On the data sheet I have a list of tail numbers and their relate
weight, arm number, and another arm number. I've successfully made
drop-down list on the calculation sheet from the tail numbers on th
data sheet.
My problem is I want the weight, arm number, and the other arm numbe
to go into there proper cell location in the calculation sheet when
select the tail number from the drop-down list. I would also like thi
to happen when I should select a different tail number from th
drop-down list.
Any Help would be grateful. I can fly a helicopter but I crash an
burn with excel.
Thanks
DolittleDustoff: