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.
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).
Bookmarks