Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Emily Diaz   on Jan 06 In MS Office Category.

  
Question Answered By: Kerry Wright   on Jan 06

Is there a macro I can copy to accomplish the following please?

Suppose this is in column A:
1> James Anderson
2> Jan 12, 1873
3> Aug 10, 1944
4> “Devoted Father”
5> William Brown
6> Feb 17, 1900
7> Jul 22, 1982
And so on…….

Ok, I highlight the first four options. Is there an easy macro to change
that to:
A
B C
D
1 James Anderson Jan 12, 1873 Aug 10, 1944
“Devoted Father”

I.e., whatever I highlight is spread across ONE row? Right now, I tried a
macro, but it pastes in the wrong cell. Automating this would save about
nine days work. After I highlight the next three rows, it gets spread out
like this:
A
B C
D
5 William Brown Feb 17,1900
Jul 22, 1982
???

I can do a sort later and remove the empty rows. Possible?

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Making a Workbook as an Active Workbook without opening it Or get search suggestion and latest updates.


Tagged: