Closed Thread
Results 1 to 3 of 3

Selecting equally spaced cells and putting the info into columns...

  1. #1
    Registered User
    Join Date
    06-14-2007
    Posts
    1

    Selecting equally spaced cells and putting the info into columns...

    OK, so I obviously need help with "Selecting equally spaced cells and putting the info into columns...". I work for a company that needs to get the info from this site here: http://unity-mail.com/unitydb/indy/indysearchnoed.php and I'm trying to get it all organized into one nice and neat excel spreadsheet. I researched things myself and I found that you can just insert the source code into excel and excel will automatically put the tables into cells. My only problem is that, if you noticed, on the site each and every person has their own "First Name", or "Last name", "Email", or whatever. I just want one "First Name" in the column A, the "Last name" part in column B, and so on and so forth. Is this possible to do in an easy method because I'm seriously not going to copy and paste the info myself, all 36,000+ times. Haha. Any suggestions are greatly appreciated. Thanks for the help!

  2. #2
    Forum Contributor
    Join Date
    12-12-2006
    Location
    New Zealand
    Posts
    151
    This is a Cross Post

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Thanks Reafidy

    jac006,

    This thread has being closed for cross posting. Please read forum rules below. If you agree to the rules then PM me and I'll unlock the post

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

Closed 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