View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LucyN LucyN is offline
external usenet poster
 
Posts: 7
Default Using Macro to Copy/Paste

Hi,
I need help with a Macro on Excel. I have a large data set. And I want to
move the numbers up to Bangor and delete the space between the two. The moves
the next set of numbers up to Baton Rouge, and delete the space after that.
(if that makes any sense?). When I record the macro and replay, it just keeps
going to the original cell. Thanks a lot!

BANGOR ME . . . . . . . . .
54 54 45 45
BATON ROUGE LA. . . . . . .
65 56 56 87