Hello,

I have a spreadsheet with a bunch of data in column A. I would like to

have a macro that starts at row 1, searches for predetermined sets of
text in A, and if found, cuts/pastes that row of text one cell up and
to the right.


Example.


Column A


Title
name
data
name
data
Title
name
test
name
test
name
data
Title


Each 'data' row and each 'test' row correspond with the 'name' above
it. Cut each 'data' row found and paste it into the the corresponding
'name' row (one above, one column over (column B)). Cut each 'name'
row found and paste it into the corresponding 'name' row (one row up
but column B).


** 'data' and 'test' rows contain other text as well, but cell will
"start" with either 'data' or 'test'. **


Rows will vary - not necessarily 'every other' because there are some
'titles' mixed in intermittently.


Any help would be appreaciated.


Thank you!