Hello all,
So thanks to some wonderful help from other members of the forum I got the below code working which copies a bunch of text from one of my sheets to another in preparation for it getting printed.
Now where this code looks there is a formula that works out if data needs to be copied from another cell. If there is data then it copies it across and the code above will then copy it to the new page when run. My problem lies when there is no data to copy. The formula returns a blank cell however the above code still copies the empty cell to the new page. Resulting in the Output sheet having lots of empty spaces at the end of each copied column.
My question is, is there a way I can get the above code to ignore certain values.
Please see the attached workbook for an example. What I would like to see on the Output sheet was just the cells that had text in them and not the spaces between.
Thanks in advance for any help anyone may be able to give.
Bookmarks