ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   UGhhhhh! Why is this so difficult - NO COPY "" (https://www.excelbanter.com/excel-discussion-misc-queries/230496-ughhhhh-why-so-difficult-no-copy.html)

Teddy-B

UGhhhhh! Why is this so difficult - NO COPY ""
 
From: Aggrevated Beyond Belief - To: Smarter Than me.....

I need to copy data from one worksheet and paste into another worksheet, but
I don't want to copy and paste "" cells. Almost the entire worksheet has
IF/Then formulas and several return "". So when I copy and paste special into
my new worksheet....even though the "" cells look blank, excel wants to print
them and screw up my one pager and make it into an eight pager....SHOOOSH - I
am so STUCK.
Please help- "TYVM"

Don Guillett

UGhhhhh! Why is this so difficult - NO COPY ""
 

More detail.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Teddy-B" wrote in message
...
From: Aggrevated Beyond Belief - To: Smarter Than me.....

I need to copy data from one worksheet and paste into another worksheet,
but
I don't want to copy and paste "" cells. Almost the entire worksheet has
IF/Then formulas and several return "". So when I copy and paste special
into
my new worksheet....even though the "" cells look blank, excel wants to
print
them and screw up my one pager and make it into an eight
pager....SHOOOSH - I
am so STUCK.
Please help- "TYVM"




All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com