Copy entire row if cell has text

**mari86** · 07-27-2015, 05:53 AM

Dear All

I am using MS Excel 2010. My sheet 1 has 3 columns. If there is any text in Column C I want to Copy the whole row to a different row at the bottom of the sheet.

Any ideas on a formula?

I have seen posts that gives programming codes but no idea what I should do with it.

Thank you for your time.

**DBY** · 07-27-2015, 06:22 AM

Hello
For a formula solution you would probably need something like:

Please Login or Register  to view this content.

This is an array formula and needs to be entered with Ctrl+Shift+Enter. It is copied across and down from A95 if your data is in A4:C92.

DBY

**mari86** · 07-27-2015, 07:18 AM

You are an absolute genius! Thank you so much!

**DBY** · 07-27-2015, 07:23 AM

Glad to have helped. My old school teachers would laugh at me being a genius, I often wore the dunce's cap!

Copy entire row if cell has text

LinkBack

Thread Tools

Rate This Thread

Display

Copy entire row if cell has text

Re: Copy entire row if cell has text

Re: Copy entire row if cell has text

Re: Copy entire row if cell has text

Thread Information

Users Browsing this Thread

Similar Threads

Find specific text in a cell within a worksheet and copy the entire row to another sheet

[SOLVED] If Or statement to check cell text and delete entire row if text is found

Copy and paste entire row based on text in row A to new workbook.

[SOLVED] Copy and Paste entire row based on multiple text strings

Find multiple keywords/text and copy entire row into new spreadsheet?

[SOLVED] If Cell = "Text" copy entire row into a different sheet

VBA Macro To Copy Entire Row To Another based on text

VBA Macro To Copy Entire Row To Another based on text

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions