Option dependant upon entry!!
 

I am trying to get a price list to work using excel!
I have all of the prices in one spreadsheet, but I need to process the
information a little differently.
I have several systems that when selected need to go to a secondary line
item to allow the user to select one or more options, how is this done? any
ideas
For example:
If I pick item 1 I need the spreadsheet to tell the customer that he must
then go ahead and pick up a subset of options ie board 1 or board 2 or no
board
Is there an easy way of doing this?
Thanks for any help I get

Option dependant upon entry!!
 

I think maybe Debra Dalgleish may have something for you at here
www.contextures.com site:
http://www.contextures.com/xlDataVal02.html
Hope that helps you get going.


"Baffled" wrote:

I am trying to get a price list to work using excel!
I have all of the prices in one spreadsheet, but I need to process the
information a little differently.
I have several systems that when selected need to go to a secondary line
item to allow the user to select one or more options, how is this done? any
ideas
For example:
If I pick item 1 I need the spreadsheet to tell the customer that he must
then go ahead and pick up a subset of options ie board 1 or board 2 or no
board
Is there an easy way of doing this?
Thanks for any help I get

Option dependant upon entry!!
 

Thanks
I think thats exactly what I want
Will find out late tonight


"JLatham" wrote:

I think maybe Debra Dalgleish may have something for you at here
www.contextures.com site:
http://www.contextures.com/xlDataVal02.html
Hope that helps you get going.


"Baffled" wrote:

I am trying to get a price list to work using excel!
I have all of the prices in one spreadsheet, but I need to process the
information a little differently.
I have several systems that when selected need to go to a secondary line
item to allow the user to select one or more options, how is this done? any
ideas
For example:
If I pick item 1 I need the spreadsheet to tell the customer that he must
then go ahead and pick up a subset of options ie board 1 or board 2 or no
board
Is there an easy way of doing this?
Thanks for any help I get