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.