Thread: Validation List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Validation List

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