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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
why Isn't any of the experts helping me? 5
Text box to encode information to worksheets. 1
Macro to copy data X number of times into a column 0
Data Validation List 1
Mail Merge Help 1
Automatically copying data from sheet1 to sheet2 2
Combining Data help? 1

Top