Extract data from separate worksheet
Results 1 to 1 of 1

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

  1. #1
    New Member
    Join Date
    Mar 2013
    Post Thanks / Like
    0 Post(s)
    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.

    • 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
    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

    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.

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