adiyen1
Board Regular
- Joined
- Dec 23, 2008
- Messages
- 64
Hai All,
I want to create combo box for below mentioned
combo box input are:-
<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
Data are -
<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
What i want to do is in combo box when i select Jakie
Jakie related data are shown in cell B4:J7 Like this
<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
Please help me
Regards,
Adiyen
I want to create combo box for below mentioned
combo box input are:-
<html><head><title>Excel Jeanie HTML</title></head><body>
| Excel Workbook | |||
|---|---|---|---|
| A | |||
| 3 | Names | ||
| 4 | Jakie | ||
| 5 | Gates | ||
| 6 | Rabert | ||
| 7 | Marshell | ||
Sheet1 | |||
</body></html>
Data are -
<html><head><title>Excel Jeanie HTML</title></head><body>
| Excel Workbook | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| I | J | K | L | M | N | O | P | Q | R | S | |||
| 3 | Jakie | Gates | Rabert | Marshell | |||||||||
| 4 | Sale date | Units | Sale date | Units | Sale date | Units | Sale date | Units | |||||
| 5 | 15/01/2009 | 2000 | 10/01/2009 | 1800 | 17/01/2009 | 1100 | 20/01/2009 | 800 | |||||
| 6 | 25/01/2009 | 1500 | 28/01/2009 | 1250 | 04/02/2009 | 1900 | 10/02/2009 | 1750 | |||||
| 7 | 16/02/2009 | 2500 | 24/02/2009 | 2700 | 28/02/2009 | 1550 | 01/03/2009 | 2050 | |||||
| 8 | |||||||||||||
| 9 | |||||||||||||
Sheet1 | |||||||||||||
</body></html>
What i want to do is in combo box when i select Jakie
Jakie related data are shown in cell B4:J7 Like this
<html><head><title>Excel Jeanie HTML</title></head><body>
| Excel Workbook | ||||
|---|---|---|---|---|
| B | C | |||
| 4 | Sale date | Units | ||
| 5 | 15/01/2009 | 2000 | ||
| 6 | 25/01/2009 | 1500 | ||
| 7 | 16/02/2009 | 2500 | ||
Sheet1 | ||||
</body></html>
Please help me
Regards,
Adiyen
