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" <Daiv_at_discussions.microsoft.com> wrote in message
> news:632AC5F2-45D2-45B7-A665-24755AE92C92_at_microsoft.com...
> > 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.
>
>
Received on Fri Jun 30 2006 - 20:23:01 PDT