jbogaty
07-20-2010, 02:40 PM
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.
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.