You need to name the range on sheet2, InsertNameDefine..., and use that
range name in the DV.

--
__________________________________
HTH

Bob

"joromajr" wrote in message
...

-- 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