Need Help With A Complicated Macro for my command button

[VBTroubles]

Hey guys i have been looking all over the net and have really struggled with how i need to go about this. Im going to take screen shots so hopefully it will make it a bit easier to explain.

I Have Two Spreadsheets With a make/model and then numbers down the side.

1.jpg

I have Another Spreadsheet That Looks Like this

2.jpg

What Im Basically Trying to do is type a whole bunch of information in. And when i select an option button, select which diagram from the drop down and click on generate it uses the information on the left side of the option button the applicable diagram according to whats selected in the drop down menu and puts them in that spreadsheet.

So it Ends up looking like this if for example option 1 was selected with diagram 1

3.jpg

any help would be greatly apreciated =]

[patel45]

no jpg please but xls