Have table header use a unique number not a generic one.

[matthardy19]

Hi all,

Just looking for help.

I have a costing sheet that spits out a table for each building if it has a qty>0. This then is put into a table which is all generated by VBA.

Each table has a Main heading which Material List- Building: "". The buildings go from 1 To 100. Currently it just provides the Generic Material List- Building: 1 , Material List- Building: 2 etc.

What I am wanting it to do is instead of it spitting out the Generic building title for it to use the Unique Building numbers which are stated in the input sheet. Say the two building which we are quoting for are 366 and 25B, the table title would look like Material List- Building: 336 & Material List- Building: 25B.

The Unique Building number are placed in the cells F2:DA2.

I have added an example document which to the current outcome and the desired outcome.

Example-
Full Sheet-
Full VBA Code-

Please feel free to ask any more question if you need more information.