Guys I ve had help from EE on this already but I am after a small change which wasnt forseen before.
The attached excel sheet copies info from 1 sheet to another sheet see vb in attached file
The problem is that it aonly copies the 1 row plus the header info I am after the header and all rows copying that have data in column C on the Pricing Sheet
so the header info plus every row from C13 down over to C29 but there is rows 19 to 23 that need to be ignored.
The header info is replicated each time for the rows
Hope this makes sense