I have a Workbook that has two worksheets. The Data is on one
worksheet and I would like to have a Validation list in the other
worksheet will get data from the first worksheet, Is this possible, I
tried and I could not go to the other worksheet.

Thanks,
Marc

Hi Marc

You have to name the range in first sheet (Insert Name Define),
and then you can use the name as reference in the other sheet.

Regards,
Per

On 13 Nov., 00:38, marc747 wrote:
I have a Workbook that has two worksheets. The Data is on one
worksheet and I would like to have a Validation list in the other
worksheet will get data from the first worksheet, Is this possible, I
tried and I could not go to the other worksheet.

Thanks,
Marc

Hi,

How would you do that. I know the Data in the first worksheet is
A9:A300 this is the data that I want to be in the Validation list in
the other worksheet.

Thanks,
Marc



On Nov 12, 3:45*pm, Per Jessen wrote:
Hi Marc

You have to name the range in first sheet (Insert Name Define),
and then you can use the name as reference in the other sheet.

Regards,
Per

On 13 Nov., 00:38, marc747 wrote:



I have a Workbook that has two worksheets. The Data is on one
worksheet and I would like to have a Validation list in the other
worksheet will get data from the first worksheet, Is this possible, I
tried and I could not go to the other worksheet.

Thanks,
Marc- Hide quoted text -

- Show quoted text -

Hi

In first sheet, elect A9:A900, goto Insert Name Define
Name the list MyList

Now goto sheet 2, select the desired cell and goto Validation List
Source: =MyList

Notice the equal sign in front of the range name.

Hopes this helps.
....
Per

On 13 Nov., 00:53, marc747 wrote:
Hi,

How would you do that. I know the Data in the first worksheet is
A9:A300 this is the data that I want to be in the Validation list in
the other worksheet.

Thanks,
Marc

On Nov 12, 3:45*pm, Per Jessen wrote:



Hi Marc

You have to name the range in first sheet (Insert Name Define),
and then you can use the name as reference in the other sheet.

Regards,
Per

On 13 Nov., 00:38, marc747 wrote:

I have a Workbook that has two worksheets. The Data is on one
worksheet and I would like to have a Validation list in the other
worksheet will get data from the first worksheet, Is this possible, I
tried and I could not go to the other worksheet.

Thanks,
Marc- Hide quoted text -

- Show quoted text -- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

Hi,
Thanks, this was what I was looking for, everything worked but when I
created the "MyList" I seclected the default "Ignore Blank" and when I
go to the Validation it still list the Blank Cells, any idea why or
what I can do so that Blank cell are not listed.

Thanks,
Marc



On Nov 12, 4:40*pm, Per Jessen wrote:
Hi

In first sheet, elect A9:A900, goto Insert Name Define
Name the list MyList

Now goto sheet 2, select the desired cell and goto Validation List
Source: =MyList

Notice the equal sign in front of the range name.

Hopes this helps.
...
Per

On 13 Nov., 00:53, marc747 wrote:



Hi,

How would you do that. I know the Data in the first worksheet is
A9:A300 this is the data that I want to be in the Validation list in
the other worksheet.

Thanks,
Marc

On Nov 12, 3:45*pm, Per Jessen wrote:

Hi Marc

You have to name the range in first sheet (Insert Name Define),
and then you can use the name as reference in the other sheet.

Regards,
Per

On 13 Nov., 00:38, marc747 wrote:

I have a Workbook that has two worksheets. The Data is on one
worksheet and I would like to have a Validation list in the other
worksheet will get data from the first worksheet, Is this possible, I
tried and I could not go to the other worksheet.

Thanks,
Marc- Hide quoted text -

- Show quoted text -- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -- Hide quoted text -

- Show quoted text -

You misunderstand the purpose of "ignore blanks"

Blank Cells in Source List

If the source list is a named range that contains blank cells, users may be
able to type any entry, without receiving an error message.

I think what you really want is a dynamic named range that will show only
non-blank cells in the range and expand as you add more items.

See Debra Dalgleish's site for creating dynamic ranges.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP


On Fri, 13 Nov 2009 09:06:24 -0800 (PST), marc747
wrote:

Hi,
Thanks, this was what I was looking for, everything worked but when I
created the "MyList" I seclected the default "Ignore Blank" and when I
go to the Validation it still list the Blank Cells, any idea why or
what I can do so that Blank cell are not listed.

Thanks,
Marc



On Nov 12, 4:40*pm, Per Jessen wrote:
Hi

In first sheet, elect A9:A900, goto Insert Name Define
Name the list MyList

Now goto sheet 2, select the desired cell and goto Validation List
Source: =MyList

Notice the equal sign in front of the range name.

Hopes this helps.
...
Per

On 13 Nov., 00:53, marc747 wrote:



Hi,

How would you do that. I know the Data in the first worksheet is
A9:A300 this is the data that I want to be in the Validation list in
the other worksheet.

Thanks,
Marc

On Nov 12, 3:45*pm, Per Jessen wrote:

Hi Marc

You have to name the range in first sheet (Insert Name Define),
and then you can use the name as reference in the other sheet.

Regards,
Per

On 13 Nov., 00:38, marc747 wrote:

I have a Workbook that has two worksheets. The Data is on one
worksheet and I would like to have a Validation list in the other
worksheet will get data from the first worksheet, Is this possible, I
tried and I could not go to the other worksheet.

Thanks,
Marc- Hide quoted text -

- Show quoted text -- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -- Hide quoted text -

- Show quoted text -