Prepopulate cell values based on selection from list

[kumar1803]

I have a list where I have banks name. Every time I select a bank from the drop down list, I would like a prepoulate cell values automatically like for example below: Any help is really appreciat

[TABLE="width: 523"]
<colgroup><col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41"> <col style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;" span="6" width="109"> <tbody>[TR]
[TD="class: xl84, width: 477, bgcolor: #84C183, colspan: 5"]SELECT A BANK HERE[/TD]
[TD="class: xl79, width: 109, bgcolor: transparent"][/TD]
[TD="class: xl79, width: 109, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, colspan: 2"]LOAN VALUES[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent, colspan: 3"]DEALER RESERVE SUMMARY[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]Loan amount[/TD]
[TD="class: xl73, bgcolor: #D9D9D9, align: right"]$25,000.00[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]Monthly payment[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D9D9D9, align: right"]$497.87[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]Sell Rate[/TD]
[TD="class: xl75, bgcolor: #D9D9D9, align: right"]7.24%[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]Number of payments[/TD]
[TD="class: xl81, bgcolor: #D9D9D9, align: right"]60[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]Buy Rate[/TD]
[TD="class: xl75, bgcolor: #D9D9D9, align: right"]2.99%[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]Total interest[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D9D9D9, align: right"]$1,946.37[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]Loan period in years[/TD]
[TD="class: xl74, bgcolor: #D9D9D9, align: right"]5[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]Total interest[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D9D9D9, align: right"]$4,871.94[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]Start date of loan[/TD]
[TD="class: xl76, bgcolor: #D9D9D9, align: right"]3/1/2015[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]Total cost of loan[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D9D9D9, align: right"]$29,871.94[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]Difference[/TD]
[TD="class: xl77, bgcolor: #D9D9D9, align: right"]0.59[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]Total Reserve[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: #D9D9D9, align: right"]2925.57[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]Dealer Reserve[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: #D9D9D9, align: right"]2047.90[/TD]
[/TR]
</tbody>[/TABLE]

 

[Roderick_E]

Easy enough, we just need to have what i call a hidden helper sheet that contains the stored data associated with each bank.
I imagine each bank has different data?