Copy data onto sheet only if cell has text

Solved/Closed
Report
Posts
1
Registration date
Tuesday September 2, 2008
Status
Member
Last seen
September 3, 2008
-
 checjb -
Hello,

I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary).

I would like the information to automatically copy across to the sheet (summary) as I type on the original page (Figures).

I would like the information to ONLY be copied if a certain cell within the orginal sheet has a specific word 'text'.

Is there a way of producing this data?

Many Thanks

Dani
Related:

2 replies

try =if(isblank(cell to be copied)," ",(cell to be copied))
26
Hi, I am really struggling...
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
0
Just a small adjustment to make this work

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
0
Posts
1
Registration date
Tuesday February 10, 2015
Status
Member
Last seen
February 10, 2015
> Winnick
This worked perfectly, thanks! I was hoping to use this for my situation, but need some help. I have a workbook file for each day of the week that gets updated. If cell E9 has text on any of the days of the week, I want to copy that text to a Monday-Friday summary workbook. Is there a variation of this formula that would help me accomplish this?
0
I too had same requirement. Provided expression was really useful. Thanks.
0
this didn't work
0
Think that suit to your purpose:

Copy in the cell where you want your text to be automatically updated:

=IF(FIND("Text",'Figures'!B20)<>0,'Figures'!A20,"")

This will copy the text of the cell A20 of your Figures sheet in the cell where you paste the formula, only if the cell B20 of your Figures sheet contains the text "Text".

Cheers
18
Hi, I am really struggling...
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
0
Isn't it same as:
=IF('Figures'!B20="Text",'FIgures'!A20,"")

Confused :-(
0
try to add if function with $ sign
eg
Smith 16 12 10 64 70 C
Jones 10 8 6 56 52 P
Tan 18 19 10 88 91 HD Dean's List
Brown 8 15 5 40 48 F





0 F 50%
50 P 80
65 C Dean's List
75 D
85 HD

This is the excel example
now in column F if I need to check the add grades to F2 and copy the formula into other
see
= B2+C2+D2+$E$9*E2

when you copy the formula with automatically change the cell range in others

try once
0
hello guys. I want to find a word in sheet 2 and automatically copy to sheet 1 by formula (using sheet1)
0
How do I implement the same function but eliminating blank cells in my second sheet where im pasting all these values?
0