No I do not want to create dependent lists. Instead I want to control a
grid of 'n' rows and 'm' columns with a set of values (or allow users
to key in his values in the grid) when an option is selected from a
list. The same grid of very same 'n' rows and 'm' columns should hold
another set of values (or allow users to key in another set of values
in the grid) when another option is slected from a list.

Otto Moehrbach wrote:
Your #2 explanation is a bit difficult to follow. Maybe you are talking
about dependent lists. An example of this is that you have a Data
Validation cell (first list), that lists the brands of automobiles, say
Ford, Chevy, Volvo, etc. Then you have other Data Validation cells with
lists that change as a function of the selection made in the first list. Is
this what you want to have? If so, maybe this site can help:
http://www.contextures.com/xlDataVal02.html

HTH Otto
"vhrao" wrote in message
oups.com...
I have a list of four options in a cell. I want to control a set of
destination cell values based on the user selection of the options from
the list. As an example: option 1 sets the destination cell values to
some numbers, where as option 2 may set the values of very same
destination cells to some other numbers.
When user selects an option from this list I want to do the following:
1) Initially reset the destination cells to zeroes
2) If user sets some values in those destination cells, I want to
remember the user set destination cell values, as applicable to
selected option and display it next time.
I am sure this has been discussed and solved problem. I am new to this.
Can someone give the right examples?

Thanks
Rao