+ Reply to Thread
Results 1 to 2 of 2

Reformat Spreadsheet

  1. #1
    Registered User
    Join Date
    10-25-2014
    Location
    Cape Coral, FL
    MS-Off Ver
    2007
    Posts
    4

    Reformat Spreadsheet

    I have 13 PDF documents, each 200 pages, that I am converting to Excel.
    When converted, everything populates into column A only. I need to retrieve specific data from column A and place into separate columns. What I need to do is where column A = OWNER, copy the name and address into separate columns until column A = BUILDER, then copy the Builder name and address into separate columns until column A = Phone. All I need is to extract the Owner and Builder from the spreadsheets. I have attached a sample of the document and highlighted the owner info in yellow and the builder info in pink. The highlights are only on the sample attached and not on the actual spreadsheets converted from PDF. Any help would be greatly appreciated.SPREADSHEET SAMPLE.xlsx

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Reformat Spreadsheet

    Try this macro

    Please Login or Register  to view this content.
    Open up the VBA editor by hitting ALT F11

    Insert a new module by hitting Insert - Module

    Paste the macro into the empty sheet

    Hit ALT F11 to get back to the worksheet.

    Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.
    Martin

+ 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. reformat VBA
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2014, 10:40 AM
  2. Excel or Access vba for spreadsheet reformat
    By lucky245 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2013, 08:42 AM
  3. Replies: 7
    Last Post: 10-12-2012, 09:53 AM
  4. Reformat Spreadsheet
    By jconnor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2010, 03:00 AM
  5. Macro to reformat spreadsheet?
    By hjchristman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2010, 06:04 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