G
Grindy
Hello all,
I've done a search of this forum as well as a google and can't seem to find
exactly what I'm looking for. Here's my question:
I have a spreadsheet that contains the data exported from an Outlook contact
list that was corrupted in Outlook. The corruptions seem to follow enough of
a pattern that having an Excel macro to assist would really speed up my
"repair" of this data so I can then import it back into a new Outlook contact
list.
Here's what I want to do:
Cut the data (it's only simple text, no formulas, etc.) from a cell, move
down to the cell below, then paste that data there.
When I try to record a macro for this, it records the "cut" operation but
nothing after that. It won't record the moving down to the next cell ( I just
used the down-arrow key ), and it doesn't do the "paste".
When I look at the macro in the VB editor, I see the code for the "cut" but
that's all.
I'm sure there's something simple that I'm missing, but don't know what it is.
Any help/suggestions appreciated.
I've done a search of this forum as well as a google and can't seem to find
exactly what I'm looking for. Here's my question:
I have a spreadsheet that contains the data exported from an Outlook contact
list that was corrupted in Outlook. The corruptions seem to follow enough of
a pattern that having an Excel macro to assist would really speed up my
"repair" of this data so I can then import it back into a new Outlook contact
list.
Here's what I want to do:
Cut the data (it's only simple text, no formulas, etc.) from a cell, move
down to the cell below, then paste that data there.
When I try to record a macro for this, it records the "cut" operation but
nothing after that. It won't record the moving down to the next cell ( I just
used the down-arrow key ), and it doesn't do the "paste".
When I look at the macro in the VB editor, I see the code for the "cut" but
that's all.
I'm sure there's something simple that I'm missing, but don't know what it is.
Any help/suggestions appreciated.