<div>
please post an example workbook with the before and after state of row data you are describing.
</div>


please post an example workbook with the before and after state of row data you are describing.

<div>
<div class="content wysiwyg-content">
Can an expert help me out with this please.<br />
<br />
This is a CSV file with the data in Column A. When I find Grp1 I want to move that row to column B<br />
<br />
AMXXX0002 (111) CHTY &nbsp; &nbsp; &nbsp;HTWW-AMPHLETT SCHLR(WXXX)<br />
Grp1 &nbsp; &nbsp; &nbsp; 5860.0000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; 666.90<br />
<br />
So if <br />
AMXXX0002 (111) CHTY &nbsp; &nbsp; &nbsp;HTWW-AMPHLETT SCHLR(WXXX)<br />
is in A3<br />
<br />
and Grp1 &nbsp; &nbsp; &nbsp; 5860.0000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; 666.90<br />
is in A4 , move <br />
Grp1 &nbsp; &nbsp; &nbsp; 5860.0000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; 666.90<br />
<br />
to B3<br />
<br />
Thanks
</div>
</div>


Can an expert help me out with this please.

This is a CSV file with the data in Column A. When I find Grp1 I want to move that row to column B

AMXXX0002 (111) CHTY      HTWW-AMPHLETT SCHLR(WXXX)
Grp1       5860.0000           0.00           0.00       0.00                         0.00         666.90

So if 
AMXXX0002 (111) CHTY      HTWW-AMPHLETT SCHLR(WXXX)
is in A3

and Grp1       5860.0000           0.00           0.00       0.00                         0.00         666.90
is in A4 , move 
Grp1       5860.0000           0.00           0.00       0.00                         0.00         666.90

to B3

Thanks

find and move cell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.