Drop-Down List Connection

[DolittleDustoff]

Working with two worksheets within one workbook. Sheet one is the calculation sheet, the other is the data sheet which the data is used in the calculations. I'm creating a weight and balance worksheet for our fleet of helicopters.

On the data sheet I have a list of tail numbers and their related weight, arm number, and another arm number. I've successfully made a drop-down list on the calculation sheet from the tail numbers on the data sheet.

My problem is I want the weight, arm number, and the other arm number to go into there proper cell location in the calculation sheet when I select the tail number from the drop-down list. I would also like this to happen when I should select a different tail number from the drop-down list.

Any Help would be grateful. I can fly a helicopter but I crash and burn with excel.

Thanks
DolittleDustoff

[Max]

See one response in your identical post in .worksheet.functions
(Please do not multi-post)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[DolittleDustoff]

Max
Thanks for the the links to the site which looks like I could get what I want to work. Let's see if I get my airplane to hover like my helicopter. Let you know when I'm airborne and soaring.

Also I posted before realizing I was posting in the wrong forum. New to this forum thing.

Again thanks for the direction.
DolittleDustoff

[Max]

Your'e welcome !
Thanks for feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DolittleDustoff"
<[email protected]> wrote in
message news:[email protected]...
>
> Max
> Thanks for the the links to the site which looks like I could get what
> I want to work. Let's see if I get my airplane to hover like my
> helicopter. Let you know when I'm airborne and soaring.
>
> Also I posted before realizing I was posting in the wrong forum. New to
> this forum thing.
>
> Again thanks for the direction.
> DolittleDustoff

[DolittleDustoff]

Max

Just got the airplane to hover. It's amazing sight to see. On with the rest of the weight and balance sheet.

I just might be back with more questions about charting points and few other functions.

Again thanks for the time to respond to a pilot that can fly a complex aircraft but can only crash an excel sheet when behind the desk.

Tailwinds
DolittleDustoff

[Max]

Delighted to hear that !

Post afresh (i.e. start new posts) on any queries, but do keep it to
one query per new post for best results from responders <g>
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DolittleDustoff"
<[email protected]> wrote in
message news:[email protected]...
>
> Max
>
> Just got the airplane to hover. It's amazing sight to see. On with the
> rest of the weight and balance sheet.
>
> I just might be back with more questions about charting points and few
> other functions.
>
> Again thanks for the time to respond to a pilot that can fly a complex
> aircraft but can only crash an excel sheet when behind the desk.
>
> Tailwinds
> DolittleDustoff