+ Reply to Thread
Results 1 to 6 of 6

Data Parsing - Segregating rows data under specific column headers - Macro creation

  1. 01-14-2016, 02:51 PM #1
    harman83
    harman83 is offline
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Data Parsing - Segregating rows data under specific column headers - Macro creation

    Hello Experts

    I have a data which is collected in One column only. I want to parse this data under specific columns headers. Can you please help me to create macro for the same

    Example:-
    Entries with hyperlinks in one column, and data below those hyperlinks under specific column headers.

    In the sheet attached -
    Current situation tab explains the data I have currently

    Required method tab is the way I want my data to be parsed.

    Kindly help me in parsing data in required way.

    ThanksBasic problem.xlsx
    Reply With QuoteRegister To Reply
  2. 01-14-2016, 03:37 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Data Parsing - Segregating rows data under specific column headers - Macro creation

    Hi Harman,

    Try this:

    Please Login or Register  to view this content.
    Last edited by xladept; 01-14-2016 at 04:17 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  3. 01-14-2016, 04:27 PM #3
    harman83
    harman83 is offline
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Data Parsing - Segregating rows data under specific column headers - Macro creation

    It worked on the sample I used.Thankyou

    But now when I am using it on original file I am facing errors.Basic problem.xlsx

    Can you please have look in the file attached. Issue seems 90% resolved, and this file is my real data

    Regards,
    Harman
    Reply With QuoteRegister To Reply
  4. 01-14-2016, 04:43 PM #4
    harman83
    harman83 is offline
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Data Parsing - Segregating rows data under specific column headers - Macro creation

    Its working, my data was having blank row..I deleted those and it worked...

    You are a rockstar....God bless you..Stay happy stay healthy..Issue resolved.
    Reply With QuoteRegister To Reply
  5. 01-14-2016, 04:54 PM #5
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Data Parsing - Segregating rows data under specific column headers - Macro creation

    Try this:

    Please Login or Register  to view this content.
    *The Required Method sheet was Required method
    Reply With QuoteRegister To Reply
  6. 01-14-2016, 04:55 PM #6
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Data Parsing - Segregating rows data under specific column headers - Macro creation

    You're welcome and thanks for the rep!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] HELP! Trying to move data in rows to match column headers
    By ablits1 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 08-31-2015, 07:00 PM
  2. Moving column headers to rows while keeping related data
    By ythgirw in forum Excel General
    Replies: 1
    Last Post: 01-07-2015, 09:20 AM
  3. [SOLVED] choosing specific data only rows from a list of which includes headers/titles/subtitles
    By unexecel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-09-2014, 06:37 AM
  4. [SOLVED] Macro for inserting specific rows with data when there is a change in the column
    By KILOJulz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2013, 04:19 AM
  5. Parsing & Segregating Outlook Mail Fields to Excel
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-05-2012, 08:08 AM
  6. [SOLVED] VBA to organise data into specific rows, using row headers
    By stephen11 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2012, 06:32 AM
  7. [SOLVED] Finding column & row headers for each showing of specific text in a table of data
    By stwilson in forum Excel General
    Replies: 20
    Last Post: 05-15-2012, 04:42 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1