Data Validation

[Muhammad Nazim uddin]

Please help me out, how do I use a consolidated drop down list by using
multiple worksheets within a workbook?

Scenario is.
Sheet1 : List of No. of Customers of Div1
Sheet1 : List of No. of Customers of Div2
Sheet1 = List of No. of Customers of Div3
Sheet1 = List No. of Customers of Div4
Sheet1 = List No. of Customers of Div5

I want to get a conlidated drop down list of all customers of all Divisions
to monitor closely the Billed Amount - Payment Received and Payment
Receivable by using Office 2003.

Thanks,
M. Nazim

 

[Eduardo]

Hi,
take a look into Debra web she has excellent examples

http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlDataVal02.html

if this helps please click yes thanks

 

[JB]

=Small(Div1iv3!$A$1:$A$10,Rows($1:1))

http://cjoint.com/?jkvdtYrYz6

http://boisgontierjacques.free.fr/pages_site/listes_cascade.htm

JB