Hi,

I have seen spreadsheets that have a drop down control that is populated by
a range of cells somewhere else in the spreadsheet. I would like to use this
technique but cannot seem to get it working. can anyone help me with this?

Also, I am going to want to reference the value of this list and assign an
equation based on it's value.

Thanks for all your help!!!
Daiv.

You can use Data Validation to create these drop down lists.

Check out these pages of Debra Dalgleish, where you can out everything about
them.

http://www.contextures.com/tiptech.html

Scroll down to the D's, and see all the pages referring to Data Validation.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Daiv" wrote in message
...
Hi,

I have seen spreadsheets that have a drop down control that is populated
by
a range of cells somewhere else in the spreadsheet. I would like to use
this
technique but cannot seem to get it working. can anyone help me with
this?

Also, I am going to want to reference the value of this list and assign
an
equation based on it's value.

Thanks for all your help!!!
Daiv.

That was very helpfull!!

Iam still unsure how to apply a function that is specified in another cell.
these functions will be applied 20+ times, and they will be referencing
different cells each time (in a predictable pattern)

When I try this i just get the value of the cell holding the formula instead
of the formula itself being applied to the cell referencing it.


Thanks again!
Daiv

"Ragdyer" wrote:

You can use Data Validation to create these drop down lists.

Check out these pages of Debra Dalgleish, where you can out everything about
them.

http://www.contextures.com/tiptech.html

Scroll down to the D's, and see all the pages referring to Data Validation.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Daiv" wrote in message
...
Hi,

I have seen spreadsheets that have a drop down control that is populated
by
a range of cells somewhere else in the spreadsheet. I would like to use
this
technique but cannot seem to get it working. can anyone help me with
this?

Also, I am going to want to reference the value of this list and assign
an
equation based on it's value.

Thanks for all your help!!!
Daiv.

You're being very general.

Post back with specific examples ... what your data configuration looks
like,
what you would like to see happen.

The more you tell us, the better we can make accurate suggestions.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Daiv" wrote in message
...
That was very helpfull!!

Iam still unsure how to apply a function that is specified in another cell.
these functions will be applied 20+ times, and they will be referencing
different cells each time (in a predictable pattern)

When I try this i just get the value of the cell holding the formula instead
of the formula itself being applied to the cell referencing it.


Thanks again!
Daiv

"Ragdyer" wrote:

You can use Data Validation to create these drop down lists.

Check out these pages of Debra Dalgleish, where you can out everything
about
them.

http://www.contextures.com/tiptech.html

Scroll down to the D's, and see all the pages referring to Data
Validation.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Daiv" wrote in message
...
Hi,

I have seen spreadsheets that have a drop down control that is populated
by
a range of cells somewhere else in the spreadsheet. I would like to use
this
technique but cannot seem to get it working. can anyone help me with
this?

Also, I am going to want to reference the value of this list and assign
an
equation based on it's value.

Thanks for all your help!!!
Daiv.

Sorry about that. i thought there was just a command or something to tell it
to take the formula instead of the value.

I am working with a sheet that calculates the velocity of water flow. the
measurements are taken many times and each time the same calculation needs to
be done. for example

DISTANCE WIDTH DEPTH REVS TIME VELOCITY AREA DISCHARGE
(m) (m) (m) (s) (m/s) (m2) (m3/s)
0.00 RB 0.00
1.00 1.000 0.00 0 40.0 0.006 0.000 0.000
2.00 1.000 0.00 0 40.0 0.006 0.000 0.000
3.00 1.000 0.00 0 40.0 0.006 0.000 0.000

The meter that was used to determine the REVS each have different formulas
to come up with the velocity. I am wanting to get a drop box that lists the
different meters (which I have accomplished), and based on the meter, have
it automatically insert the correct formula in each VELOCITY cell.

Currently I have the list items stored in adifferent sheet, and want to put
the formula in a cell beside the list item so the list can grow/shrink easily
as time goes on.

The velocity formulas use the width, revs and time values in each respective
row.

I hope this helps. Let me know if you need more info.

Daiv.

"RagDyeR" wrote:

You're being very general.

Post back with specific examples ... what your data configuration looks
like,
what you would like to see happen.

The more you tell us, the better we can make accurate suggestions.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Daiv" wrote in message
...
That was very helpfull!!

Iam still unsure how to apply a function that is specified in another cell.
these functions will be applied 20+ times, and they will be referencing
different cells each time (in a predictable pattern)

When I try this i just get the value of the cell holding the formula instead
of the formula itself being applied to the cell referencing it.


Thanks again!
Daiv

"Ragdyer" wrote:

You can use Data Validation to create these drop down lists.

Check out these pages of Debra Dalgleish, where you can out everything
about
them.

http://www.contextures.com/tiptech.html

Scroll down to the D's, and see all the pages referring to Data
Validation.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Daiv" wrote in message
...
Hi,

I have seen spreadsheets that have a drop down control that is populated
by
a range of cells somewhere else in the spreadsheet. I would like to use
this
technique but cannot seem to get it working. can anyone help me with
this?

Also, I am going to want to reference the value of this list and assign
an
equation based on it's value.

Thanks for all your help!!!
Daiv.

how many meters/formulas do you have and how do the formulas differ?there
will have to be an identifier on your table to know which meter/formula to
use
--
paul

remove nospam for email addy!



"Daiv" wrote:

Sorry about that. i thought there was just a command or something to tell it
to take the formula instead of the value.

I am working with a sheet that calculates the velocity of water flow. the
measurements are taken many times and each time the same calculation needs to
be done. for example

DISTANCE WIDTH DEPTH REVS TIME VELOCITY AREA DISCHARGE
(m) (m) (m) (s) (m/s) (m2) (m3/s)
0.00 RB 0.00
1.00 1.000 0.00 0 40.0 0.006 0.000 0.000
2.00 1.000 0.00 0 40.0 0.006 0.000 0.000
3.00 1.000 0.00 0 40.0 0.006 0.000 0.000

The meter that was used to determine the REVS each have different formulas
to come up with the velocity. I am wanting to get a drop box that lists the
different meters (which I have accomplished), and based on the meter, have
it automatically insert the correct formula in each VELOCITY cell.

Currently I have the list items stored in adifferent sheet, and want to put
the formula in a cell beside the list item so the list can grow/shrink easily
as time goes on.

The velocity formulas use the width, revs and time values in each respective
row.

I hope this helps. Let me know if you need more info.

Daiv.

"RagDyeR" wrote:

You're being very general.

Post back with specific examples ... what your data configuration looks
like,
what you would like to see happen.

The more you tell us, the better we can make accurate suggestions.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Daiv" wrote in message
...
That was very helpfull!!

Iam still unsure how to apply a function that is specified in another cell.
these functions will be applied 20+ times, and they will be referencing
different cells each time (in a predictable pattern)

When I try this i just get the value of the cell holding the formula instead
of the formula itself being applied to the cell referencing it.


Thanks again!
Daiv

"Ragdyer" wrote:

You can use Data Validation to create these drop down lists.

Check out these pages of Debra Dalgleish, where you can out everything
about
them.

http://www.contextures.com/tiptech.html

Scroll down to the D's, and see all the pages referring to Data
Validation.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Daiv" wrote in message
...
Hi,

I have seen spreadsheets that have a drop down control that is populated
by
a range of cells somewhere else in the spreadsheet. I would like to use
this
technique but cannot seem to get it working. can anyone help me with
this?

Also, I am going to want to reference the value of this list and assign
an
equation based on it's value.

Thanks for all your help!!!
Daiv.