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
I have tried looking for something similar on here but cannot seem to find anything that suits my needs.
Thanks in advance