populate a row based on cell input

[torreyanderson]

I have a dropdown list on sheet1. Column A of sheet2 contains the list items. Columns B thru M on Sheet2 contain data related to Column A.

Can I make a selection from my dropdown list on sheet1 that will then copy and paste the data from Columns B thru M from Sheet2 to the ROW in Sheet1 where I made the dropdown selection?


Basically, I am trying to create a bid spreadsheet that has multiple calculators that I have already created and stored one calculator per row in sheet2. Column A of sheet2 is the name of the calculator.

When I create a bid on sheet1, I want to be able to select a calculator (Row) from the dropdown list and have only that row (from B to M) from sheet2 copied into my bid sheet.

 

[torreyanderson]

Thank you so much. Works perfectly!

 

[Fluff]

You're welcome & thanks for the feedback.