Hi,

Good day, can anybody help me, actually I dont know how to describe the
problem, I will just give the things that I've done.

SCENARIO 1:

I'm making a PUNCH Lists / CHECK Lists, but the items are per locations. see
below example

A1: LOCATION B1: <drop down lists using Data Validation
ROOM1
ROOM2
ROOM3

What I want is, when I choose the location on B1 <eg: ROOM1, all the items
in ROOM 1 will show on the B3, B4,B5,B6 ....B10,

I've define the name accordingly

ROOM1 ROOM2 ROOM3
Bed Bed Bed
Table Table Table
Headboard Headboard Headboard
Cup Sofa Refrigerator
Spoon Electricfan Computer
LCD TV Table Lamp
Sofabed


CHECKLISTS TEMPLATE

A1: LOCATION B1: <drop down lists using Data Validation
ROOM1
ROOM2
ROOM3

If I choose ROOM1, then all the Items in Room1 will show as follows

A2: SN B2 : ITEMS
A3: 1 B3: Bed
A4: 2 B4: Table
A5: 3 B5: Headboard
A6: 4 B6: Cup

and the same as ROOM2 and ROOM3, I know that I can use =indirect(b1) in the
Data Validation as a drop down lists, but we dont want to use the drop down
lists.

Please help.

thank you.