+ Reply to Thread
Results 1 to 12 of 12

How to populate the data accordingly into a table with fixed header from raw file?

  1. #1
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    How to populate the data accordingly into a table with fixed header from raw file?

    I need to manual compile the data into fixed header table from the raw file.

    Layout of raw file is fixed however the length of data (how many row) doesn't fix. The row of data will be changed every thing when generate from system.

    How to populate the data from raw file into new worksheet with fixed heard table?

    Please refer to file attached for sample raw file and result wish to.
    Attached Files Attached Files
    Last edited by Shermaine2010; 05-13-2015 at 04:27 AM.

  2. #2
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Please help.
    Thanks

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Hi Shermaine2010

    Try this Code in the attached...CTRL + x will fire the Code.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Forum Contributor
    Join Date
    10-08-2006
    Location
    Walnut, CA
    MS-Off Ver
    2003,2010, Office 365
    Posts
    114

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Another solution!
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Thanks.....................
    Last edited by Shermaine2010; 05-12-2015 at 09:35 PM.

  6. #6
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Quote Originally Posted by jaslake View Post
    Hi Shermaine2010

    Try this Code in the attached...CTRL + x will fire the Code.
    The raw file attached by you doesn't same as my raw file. It is mean that I need to manual adjust before run the code.

    Example: Name in column D (yours) and column E (mine).

    Thanks

  7. #7
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Quote Originally Posted by TonyS View Post
    Another solution!
    Code can't found in the file attached. Thanks

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    This should do for the data you have uploaded.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Quote Originally Posted by jindon View Post
    This should do for the data you have uploaded.
    Fantastic..

    However, my raw file have additional information at top and bottom. The code copied these information over as well.
    Please share how to remove those unecessary information plus buil summary table beside that.

    Sample attached.
    Attached Files Attached Files

  10. #10
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Quote Originally Posted by jindon View Post
    change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Good job. Thanks

  12. #12
    Forum Contributor
    Join Date
    10-08-2006
    Location
    Walnut, CA
    MS-Off Ver
    2003,2010, Office 365
    Posts
    114

    Re: How to populate the data accordingly into a table with fixed header from raw file?

    Sorry, left in a hurry yesterday. Here's the code. add a new tab named "Final" then run the code.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro to import varying data rows into fixed table
    By aselly22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2014, 12:51 AM
  2. [SOLVED] Create sheets named by header and populate them with sorted data
    By salaso69 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-16-2013, 03:47 PM
  3. Replies: 0
    Last Post: 08-28-2012, 04:36 PM
  4. Reference / retrieve data from a table and populate a table in a different workbook?
    By philuptuous in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-17-2012, 06:21 AM
  5. [SOLVED] [SOLVED] Define and Reference fixed data in a table
    By RedHook in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-12-2006, 12:00 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1