If cell has text then go to sheet x and insert [Closed]

Question

If cell has text then go to sheet x and insert [Closed]

Report

Finfool - Updated by Finfool on 7/02/17 at 12:35 PM
Finfool - Feb 7, 2017 at 01:23 PM

Hello,

I need a formula that can insert text on another sheet.

So sheet 1 A1 has text then take that text insert it into Sheet 2 line "to be determined" and add this text with it.

If cell has text then go to sheet x and insert
Copy to cell below the last entry in Sheet 2 ✓ - Forum - Excel
Google sheets if cell contains any text then ✓ - Forum - Excel
Excel copy row to another sheet based on cell value ✓ - Forum - Excel
Excel if cell contains text then copy to another sheet ✓ - Forum - Excel
How to copy cells from one sheet to another in excel using formula - How-To - Excel

1 reply

Ask a question

Finfool · Answer 1 · 2017-02-07T13:23:16-0500

Answer 1 / 1

Finfool
Feb 7, 2017 at 01:23 PM

=IF('Sheet1'!B16 <> "","Bob "&'Sheet1'!B16,"!")

If cell has text then go to sheet x and insert [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!