Help with workbook formulas

[Bravo33]

This is a construction estimating based problem I am hoping the community can help me solve.

Please refer to the enclosed Workbook. I have input comments against certain cells

I have a spreadsheet with a Schedule of Works.

I will manually be coding up the Trades ie C60; X10 and so on.
There is a parent/child relationship between heading and elements ie Parent = 1; Child =1.1 ,1.2, 1.3 and so on.
Note that more than 1 trade code can be associated with an item. I have used the ";" as the delimeter.

Ideally when a new Trade code is generated I would like it to automatically generate a new spreadsheet and copy all items with that trade code to the generated spreadsheet. In the right order.

Once that has been generated I will need to be able to input rates against items on each of the trade tabs and for the Schedule of Works to lookup the rates.

Any assistance greatly appreciated

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.