Prev: Replacing a data range in a nested array function
Next: formula range doesn't update for new rows
From: Xman on 24 Feb 2010 14:11
Is it possible to have a list range in one cell based on the inputed
information in that cell? IE, I have a packing list for 3 different
products, and 3 different master lists. On the 1st list, I have added in
list form in one cell the 3 different lists I could possibly generate. Is it
possible to change a list reference in the same cell based on the list I want
to generate?
--
JARoman
From: Eduardo on 24 Feb 2010 14:16
Hi,
I think you need dependent list see Debra web

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

"Xman" wrote:

> Is it possible to have a list range in one cell based on the inputed
> information in that cell? IE, I have a packing list for 3 different
> products, and 3 different master lists. On the 1st list, I have added in
> list form in one cell the 3 different lists I could possibly generate. Is it
> possible to change a list reference in the same cell based on the list I want
> to generate?
> --
> JARoman
 | 
Pages: 1
Prev: Replacing a data range in a nested array function
Next: formula range doesn't update for new rows