Related:

- Excel if cell contains text then copy to another sheet
- Excel if cell contains text then copy row to another sheet - Best answers
- If cell contains text copy row to another sheet - Best answers
- Copy rows based on a condition ✓ - Forum - Excel
- Excel - Comparing cell A1 to entire A column in Sheet 2 - How-To - Excel
- IF-Then statement to copy rows ✓ - Forum - Excel
- Copy row if a range of column matches a value ✓ - Forum - Office Software
- Find string/date, copy row to another sheet - Forum - Excel

## 2 replies

Niko

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

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

Charlie

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

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

If it is purely for esthetical reasons this might be the easiest option.