Find cell with specific text in a row, then rearrange the columns

**cyin** · 03-31-2012, 04:59 AM

I would like to search cell with contains of specific text "amount" in the different columns in a row from Sheet1. There might be more than one column with "amount". Once the cells with "amount" found, I need to rearrange the cell in another worksheet(Sheet2) with first display the cell with "amount"(1st found amount), "amount"(2nd found) and subsequent "amount" found. After that, will need to display the rest of the cells in the same row.

sorry that I cant describe my problem very well. appreciate you can refer to the my attachment and advice accordingly. Thank you very much for helping

**mrice** · 03-31-2012, 08:32 AM

Try this macro

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.

Select the rows that you want to process before running it.

**cyin** · 03-31-2012, 10:39 PM

Thanks mrice for your prompt response. It was so helpful and it work greats.
May I know if it possible to have the macro apply for the whole worksheet instead of doing it row by row?

Many thanks for your helping. Thanks again and wish you have a good day!

**mrice** · 04-02-2012, 03:45 AM

The code will work if you select multiple rows. If there are no blank rows in your dataset, then selecting any non-blank cell and hitting CNTRL-SHIFT-8 will select all the relevant cells - then run the macro.