Results 1 to 2 of 2

Thread: Extract data from separate worksheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2013
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Extract data from separate worksheet

    First, apologies for vagueness as I don't really know how to approach this.

    I am exporting reports that are providing customer info that I need to consolidate into single lines. Unfortunately, the export is designed in a pdf/printable report format. The objective is to copy updated data into an input worksheet that then reformats the customer information in single lines that I can filter to create follow-up activity. There is both a header and footer on each "page" which I will try to represent below.

    Notes:
    • Each "page" has 8 rows on top (shown below) with the report name, business name, and address, customer type, then header row.
    • Each "page" has 4 rows on the bottom, 3 blank and 1 with the printed time/date and page # of #
    • Customer detail is framed in 5x20 sequences, but periodically the customer type changes so the number of customers per page is not consistent.
    • Each 5x20 customer block is the same, except swap out the phone type (ex: cell could be home, the blank cell between and some cells may be blank. Ideally my consolidated row returns a blank value if the cell is blank.

    Report name xxxxxx
    xxxxxx
    xxxxxx
    xxxxxx
    xxxxxx
    XXXXXX
    Customer Type: Sample
    Customer Contact Information Activity Balances Last Payment
    Last, First Cell : 123-456-7890 First: 05/19/2016 Services: $0.00 05/14/2019
    123 Main St
    City, ST zip Work : 123-456-7890 Last: 06/18/2019 Discount: $0.00 $185.00
    Email : email@example.com Next: 06/27/2019 Account: $0.00
    Printed: Wednesday, June 19, 2019 9:33:50 AM Page 1 Of 332

    I would like to return data under these headers
    Name Email Cell Work Last Activity Next Activity Account
    Balance

    While a direct answer to this is welcome, even suggestions as to functions I should be looking into would be terrific.

    Thank you!
    Last edited by searnold56; Jun 19th, 2019 at 10:49 AM.

  2. #2
    New Member
    Join Date
    Mar 2013
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Extract data from separate worksheet

    Bump

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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