+ Reply to Thread
Results 1 to 4 of 4

Macro to sort dynamic list into table

  1. #1
    Registered User
    Join Date
    04-01-2007
    Posts
    12

    Macro to sort dynamic list into table

    Hello everyone please could someone take a look at a macro for me?
    I have a list of letting agents that I need to sort into a table to import into Access. The list is dynamic in that not all the fields are present for every record.
    I will have over 4000 records to sort out, so I would really like to automate this.
    If possible the macro should read rows from the data worksheet and write to columns and rows on the Table worksheet.
    I have attached a small example of the data and output required.
    To make it a little more challenging the column header name is part of the data and will need stripping out as well.

    Thanks for looking.

    Regards
    Andrew


    Lettings Agents.xls

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Andrew

    See how this goes.

    Please Login or Register  to view this content.
    rylo

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Andy748,

    Here is another macro for you to copy the data into a table. Theis macro has already been added to the attached workbook.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-01-2007
    Posts
    12

    A big thank you.

    Thanks guys both macros worked, but I went with rylo's as the data was more dynamic (messy) than I first thought.
    Two good macros though, I am still trying to work out exactly how they work, as that is the important bit for me.
    Thanks once again Leith Ross and rylo.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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