copy data from one worksheet and disregard blank cells
Glad I could help
"Allan" wrote:
Thanks Mike,
Such a simple solution, that's probably why I couldn't findit.
Thanks Again
"Mike H" wrote:
Allan,
Select the top cell of your range then
Data|Filter|AutoFilter
On the Autofilter dropdown select 'Non Blanks'
Select all your data and Copy
paste it into the new location and the blank rows are gone
Mike
"Allan" wrote:
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.
|