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

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

"Muhammad Nazim uddin" wrote:

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

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

http://cjoint.com/?jkvdtYrYz6

http://boisgontierjacques.free.fr/pa...es_cascade.htm

JB


On 10 sep, 18:57, Muhammad Nazim uddin
wrote:
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