Select and Copy a Set of Data in a Column based on starting and Ending Values

AGALLEGOS

New member
Joined
Aug 26, 2013
Messages
1
Reaction score
0
Points
0
I have a macro that copies three sections of data from a word document and pastes it within the Excel worksheet. The column of data is pasted in a single column starting at A1 (data to be space-delimited and evaluated later), and what I would like the MACRO to do is separate the three sections of data based on the starting and ending values of the section and place them in different columns.


Section 1 : starts with the word "Team"
Section 1 : ends with the word "City"


Section 2 : starts with the word "Location"
Section 2 : ends with the word " Date"


Section 3 : starts with the word "Member"
Section 3: ends with the word "Age"


So section 1 would be pasted into cell C1, section 2 pasted into G1 and section 3 pasted into J1.
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
2010
I may be misunderstanding something, but you obviously know where the breakpoints for the sections are. Can't you create a break line at the end of each section (In Word)? When the text is pasted into Excel, the sections will then be clearly identified and it will be a simple task to manually cut and paste sections 2 and 3 into the correct columns (or use the macro if you like).
 
Top