Thread: data validation when list is on a different worksheet? 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joromajr joromajr is offline
external usenet poster
  
Posts: 30
Default data validation when list is on a different worksheet? 2003

-- 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
Reply With QuoteReply With Quote