Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    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).

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •