Copy data onto sheet only if cell has text
Solved/Closed
danipants
Posts
1
Registration date
Tuesday September 2, 2008
Status
Member
Last seen
September 3, 2008
-
Updated on Nov 25, 2017 at 02:24 AM
checjb - Jan 29, 2019 at 07:40 AM
checjb - Jan 29, 2019 at 07:40 AM
Related:
- If cell contains text then copy to another sheet
- Excel if cell contains text copy row to another sheet - Best answers
- Excel if cell contains text then copy to another sheet - Best answers
- Conditional formatting if cell contains text - Excel Forum
- If a cell has text then return value ✓ - Excel Forum
- Google sheet right to left - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Windows network commands cheat sheet - Guide
Jan 16, 2009 at 07:18 PM
I have a very large order sheet in XL and when the customer enters the qty they want in a column there will always be many in that column with no qty in. to print the order I want to have all the data moved to another spreadsheet so I only see the items they have ordered not the whole sheet with the items they have not
can you help I have tried a few things but cannot get the formular right
Thanks
Rebecca
Mar 17, 2010 at 07:12 AM
the formular goes into the cell where you want data to be copied into
=if( cell to be copied = isblank(true), " ", Cell to be copied )
and it easier if you name the cells you're working with as mentioned.
example:
We name the cell we want to copy on sheet 1 "Quantity" and we work in sheet 2
On sheet 2:
= if(Quantity= isblank(true), " ", Quantity)
This will check if the field named Quantity on sheet 1 is blank - if it is, it will insert a blank space in the field on Sheet 2, if Quantity is not empty - then Quantity will be copied to A1