Drop Down VAB and fill rows

[pantakos]

Hello,

I have the following file that consists of two sheets. One DATA and other PROFORMA , I need to make a drop down menu at customer cell that get data from data sheet.
When I choose a customer then automatic fill all the other rows at PROFORMA sheet that are necessary. The rows need to be filled are in yellow color.
The rows at data sheet will be around 5000. A lot. If this can be done with VBA then will be wonderfull.

Please find attached the file uploaded at GDrive

I just saw it. VAB = VBA ...


Thank you!

 

[pantakos]

This cross posted at Drop Down VBA and fill rows