how to display several items in one form with reference coming from other sheet?

Len Cun

New Member
Joined
Jul 17, 2018
Messages
11
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:
Case No.9-12345
Franchise Route:Manila-Pampanga
Expiry CPC:Sep 30 2018
EOV Date:Aug 03 2018
Bus NoEngine NoChassis No
1abc-123456cde-987654
2efd-657890tre-098765
3pto-098123rto-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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,213,551
Messages
6,114,272
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top