Copying multiple lines of code for shop drawings

[Mr_Asparagus]

Hi all,

I've recently been tasked with upgrading our somewhat dated Excel spreadsheets in the hope that they can generate a more end-user friendly print out for shop drawings.

I've attached a copy of the spreadsheet, information is being pulled from the 'Door Information' sheet & transposed into the 'Level B' sheet. I've input the basic formulas to pull the first line's information which is Door No. D04 (cell ref: B6).

My question is: How can I get the remaining lines to populate onto Level B sheet without having to manually enter the formulas? Sorry for the poor explanation, hopefully the attached can give a bit of a guide to what I'm trying to achieveShop Drawing Template.xlsm

[AskMeAboutExcel]

A couple of options:

1) Create a dropdown of all the different door numbers, then use VLOOKUP to pull through the individual details throughout the template based on the selected door. Instead of having over 40 repetitive templates, you will only need one
2) Use a fair amount of macros / VBA coding

Which option you want to go down depends on your use case.

Note that in cell B7 of your 'Level B' worksheet, one of the cells is referencing row 7 of the 'Door information' sheet, whereas all others are row 6. Is this intentional?