Excel Macro Help

[jbogaty]

I am trying to create a macro that will search a specific range of cells for a certain criteria ("DOE") and will then copy the entire cell that matches that criteria and pastes it in a specific row.

Basically, the current excel sheet looks like this:

Model # Serial #
C760 450WL123
DOE8237423 D360
X7564S DOE8234272

I know I will have to separate the Model # and the Serial # manually, but, every ASSET ID # has the letters DOE infront.

I want this to happen with the 3 entries above:

Model # Asset ID # Serial #
C760 450WL123
DOE8237423 D360
X7564S DOE8234272

I just started to use macros, I just don't know how to make the right script.

[jbogaty]

hmm, my formating didnt work.... {} means column separation.

Model # {}{}{}{}{}{}Serial #
C760 {}{}{}{}{}{}{}450WL123
DOE8237423{}{}{}{} D360
X7564S{}{}{}{}{}{} DOE8234272



Model #{}{}{}{}{ Asset ID # {}{}{}{}{Serial #
C760{}{}{}{}{}{}{{}{}{}{}{}{}{}{}{ 450WL123
}{}{}{}{}{}{}{}DOE8237423{}{}{}{}{}D360
X7564S{}{}{}{}{DOE8234272

[mbarron]

Please post a sample workbook with the before and after.