Create a macro to move info from one column to another
You need to make the macro be in a "For...Next..." or "For...While..." style.
add your recorded macro to a response and people can show you common ways of
expanding it to be more general.
"John" wrote:
I have a list that has first names and middle intiials in the same column. I
want to create a macro to cut the initial and the period and paste it into
the next column over.
I have recorded a macro that does it, once. But I don't understand how to
get it to keep working through the whole list.
Thanks.
--
John
|