data validation when list is on a different worksheet? 2003

J

joromajr

-- Please help, I am trying to use data validation on sheet1 but the list
is on sheet 2

In sheet1 b1 column name is account code. In sheet2 colume A are Account
code and sheet2 Column B are the corresponding Account names.

What need to do is before I encode on Sheet1 Column C the invoice numbers I
need to select first the correct account code and account name.

Please help.

joromajr
 
B

Bob Phillips

You need to name the range on sheet2, Insert>Name>Define..., and use that
range name in the DV.
 
Top