I have data on one worksheet that needs to be copied onto another. The new
worksheet must have this data however it must diregard the blank cells.
I cannot sort and then delete as each cell contains a formula that
references another worksheet.
a1 = abc
a2 = def
a3 = blank cell
a4 = fgh
a5 = ijk

Many Thanks
Allan
new worksheet should read as
a1 = abc
a2 = def
a3 = fgh
a4 = ijk
there is no longer a blank cell and the total rows has been reduced by the
number of blank cells the original worksheet contained.