Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 them and screw up my one pager and make it into an eight pager....SHOOOSH - I am so STUCK. Please help- "TYVM" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect "Copy" and "Save As" changes to workbook | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) |