hi Admin!
please help me..
how to create a form that will show a summarized data coming from another sheet. id like to know how to create a fillable form wherein when you enter a certain text(case No.), it will display all related details. example:
sheet1(contains all data)
sheet2("supposed form" where i will enter the text)
sheet 2 would look like this:
<tbody>
</tbody>
<colgroup><col><col span="3"><col><col span="2"></colgroup><tbody></tbody>
When I entry the case no. all the details will be shown.
I tried the vlookup formula, but i cant find the right formula wherein it will automatically display all the bus No. w/corresponding details at once, when i enter the case number.
each case no.has several buses under the same case with different engine and chassis no.
please help.thanks in advance!
Len
please help me..
how to create a form that will show a summarized data coming from another sheet. id like to know how to create a fillable form wherein when you enter a certain text(case No.), it will display all related details. example:
sheet1(contains all data)
sheet2("supposed form" where i will enter the text)
sheet 2 would look like this:
Case No. | 9-12345 | |
Franchise Route: | Manila-Pampanga | |
Expiry CPC: | Sep 30 2018 | |
EOV Date: | Aug 03 2018 | |
Bus No | Engine No | Chassis No |
1 | abc-123456 | cde-987654 |
2 | efd-657890 | tre-098765 |
3 | pto-098123 | rto-098345 |
<tbody>
</tbody>
<colgroup><col><col span="3"><col><col span="2"></colgroup><tbody></tbody>
When I entry the case no. all the details will be shown.
I tried the vlookup formula, but i cant find the right formula wherein it will automatically display all the bus No. w/corresponding details at once, when i enter the case number.
each case no.has several buses under the same case with different engine and chassis no.
please help.thanks in advance!
Len