Vlookup or macro to auto fill next few rows

[sinned141]

I have a master sheet which has different build ups of roofing system. I would like to be able to (select or type) the system in column B of a separate workbook and the have Column C autofill with the components (this can be anything from 1 to 10 rows) hen have a blank row and continue with another selection (which may be the same or a different build up)

I have tried looking for something similar on here but cannot seem to find anything that suits my needs.

Thanks in advance

 

[My Aswer Is This]

I'm not sure what this means:
"I would like to be able to (select or type) the system in column B of a separate workbook"

You mean another "Workbook"
You want to enter values in one workbook and then copy to another workbook?
You subject title says:"to auto fill next few rows "

Please explain

 

[oldbrewer]

[TABLE="width: 896"]
<colgroup><col span="14"></colgroup><tbody>[TR]
[TD="colspan: 3"]simulated master sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]simulated component sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof1[/TD]
[TD]tiles3[/TD]
[TD]wooda[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]roof3[/TD]
[TD]tiles1[/TD]
[TD]woodc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof2[/TD]
[TD]tiles4[/TD]
[TD]woodd[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof3[/TD]
[TD]tiles1[/TD]
[TD]woodc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]roof8[/TD]
[TD]tiles2[/TD]
[TD]wooda[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof4[/TD]
[TD]tiles2[/TD]
[TD]woodb[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof5[/TD]
[TD]tiles3[/TD]
[TD]woodd[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]roof6[/TD]
[TD]tiles4[/TD]
[TD]woodc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof6[/TD]
[TD]tiles4[/TD]
[TD]woodc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof7[/TD]
[TD]tiles1[/TD]
[TD]woodb[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof8[/TD]
[TD]tiles2[/TD]
[TD]wooda[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof9[/TD]
[TD]tiles3[/TD]
[TD]woode[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]roof10[/TD]
[TD]tiles4[/TD]
[TD]woode[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]formula giving tiles1 for roof3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]=OFFSET($A$2,MATCH($I3,$A$3:$A$12,0),1)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[sinned141]

Hi My Answer Is This, my apologies
I have been out of practice and am not explaining myself well.

I have several sheets in a workbook, each sheet corresponds to a different roofing system. each system has different build ups for different areas.
e.g.

Column B Column C
Hotmelt Primer
Reinforcement mesh
Compound
Capsheet

Inverted VCL
Insulation
Capsheet





In another workbook i would like to be able to select the system being used (one of the Sheets in the original Workbook) and then be able to either select from a drop down in column B or Type into column B the type of build up e.g. "Hotmelt" and then for Column C to fill with the corresponding build and then leave one row of space and select another in column B.

Or to put the required build ups into Column B and then run a macro after to create the fill.

Hopefully that explains it better, if not i will try and look up how to insert the screen shots as it has been a while sine i have been on.

 

[sinned141]

Thanks for the response Oldbrewer, again apologies for my explanation.
I can see my second attempt has also not come out as I wanted.

Column B__ Column C
Hotmelt __ Primer
"blank" __ Reinforcement mesh
"blank" __ Compound
"blank" __ Capsheet

Inverted __ VCL
"blank" __ Insulation
"blank" __ Capsheet

hopefully that layout will be more readable, i would appreciate knowing how to space them properly though.
Column C may have between 1 and 10 components listed for the build up of each type

 

[My Aswer Is This]

Sorry if we may not understand but we always need exact details.
Now you said:
In another "Workbook"

So this means we are dealing with two "Workbooks"

So we would need to know what is the name of the two Workbooks.
We would need to know the name of the sheets we are dealing with
And maybe more.

Still not sure why your subject title says "macro to auto fill next few rows"

Sounds like we are doing a lot more then just filling next few rows.

 

[sinned141]

Again my apologies if the title is misleading.
Workbook "System Types" will be the Workbook that contains different system types (Sheets) "Axter","Bauder","Radmat" there will be several based on different manufacturers.
within each Sheet there will be breakdowns as shown in above post
.
I would like to be able to use these to create quotes in separate Workbooks (one for each quote, named as site address) I need to create the build ups then be able to add , area and prices to other columns after.