+ Reply to Thread
Results 1 to 2 of 2

need to export 2 CSV files (from two different pdfs) and merge into one line in excel

  1. #1
    Registered User
    Join Date
    12-04-2023
    Location
    USA
    MS-Off Ver
    Microsoft Office Standard 2016
    Posts
    3

    need to export 2 CSV files (from two different pdfs) and merge into one line in excel

    thank you for your help on previous posts. having issues of blank variable dropping, also need to add some steps. attached files..

    need to export 2 CSV files (from two different pdfs) and merge into one line in excel in the correct variables.

    the the workflow has the customer fill out "customer fill out Form" pdf with device then goes to the production person where he fills out "Tech fill out form" pdf. any information can be over written by "Tech fill out form" pdf data.

    the one excel line of data may have information that can be overwritten by the "Tech fill out form" pdf data.

    once this is done the one excel line needs to go into a "master data from both forms" pdf list in the correct variables that will be added too. i hope this makes sense.

    attached 3 files..

    if you have any other ideas/workflows please let me know.

    Thank you

    mike
    Attached Files Attached Files
    Last edited by michaelkanalas; 01-03-2024 at 10:46 AM.

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: need to export 2 CSV files (from two different pdfs) and merge into one line in excel

    All I could do for you was import the two PDF files using Power Query (recommended) and transform your tables into named tables.

    For further help more information is needed.
    Attached Files Attached Files

+ 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. [SOLVED] Export pdfs automatically from data validation list
    By Louise Alice in forum Excel General
    Replies: 9
    Last Post: 09-08-2022, 05:38 AM
  2. [SOLVED] Export specific sheets to individual PDFs and rename each one adding an incremential no
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2019, 10:59 AM
  3. Export Sheets Selected in ListBox as separate PDFs
    By abulkhairi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2017, 09:33 AM
  4. VBA export sheets as PDFs, merge with existing PDFs
    By wannabeexcelguy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2015, 07:32 PM
  5. Replies: 0
    Last Post: 06-24-2015, 02:34 AM
  6. Need help Merge PDFs using VBA
    By JieJenn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2012, 01:13 PM
  7. Macro Needed to Loop, Save, and Name Excel Files as PDFs
    By ahkarchem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2012, 10:46 AM

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