Well yes that has done the trick thank you so much for help. I did try to set a counter but did not get the result I wanted. I did work out how to ...
Catalin Bombea said That's where you had the printpreview line, made no change to that. Move it between Next j and Next i (between the 14 columns lo...
Initially it did seem to work correctly but now that have spent some time checking it few issues. I have put more data in, but is not working as it...
Yes I have tried that and it does print the sheet after the 14 column loop, but then prints a blank sheet for each of the sheets that no values have b...
Wow yes this does work and copies and pastes to correct location, only issue it seems is that it does the PrintPreview on each loop. As there are 1...
Now that looks great I like the spinner and the colored cell below when you changed, but as I do need the number above as a formula further down the c...
Thanks for your reply, it works but not very well Please find workbook below