Forum Discussion

Karthik0203's avatar
Karthik0203
Copper Contributor
Jan 13, 2020

Pulling selected data from multiple invoices to an excel sheet using VBA

Hello Guys,

 

Is it possible to pull selected data from multiple invoices to an excel sheet through VBA ? If so kindly help me out with the same ?

 

Thanks

BI & Data Analysis
excel
Macros and VBA

5 Replies

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Jan 14, 2020

        Karthik0203 

        You're going to need VBA scripted for this one because of the arrangement of the invoices.  It's do-able.  Other factors that need to be taken into consideration for the script.

         

        - The location of the files

        - Arrangement of the invoice data - are the values you need always in the same cells?

         

        VBA could open the workbooks, fetch the data and write it to the destination workbook then close it.  Repeat for each workbook.

  • mathetes's avatar
    mathetes
    Gold Contributor
    Jan 13, 2020
    You are far more likely to get a helpful response if you upload samples of the invoices you'd be working with. Presumably they are electronic, but are they PDF, Word, Excel, something else? Are they all consistent in format?
    And if you already have an Excel sheet into which you're expecting to place the data, upload a sample of that too.
    • Karthik0203's avatar
      Karthik0203
      Copper Contributor
      Jan 14, 2020

      Himathetes.

       

      Sorry for the late response, i have hereby uploaded two sample invoices (PDF) and an sample excel sheet which consists of the expected data which is numbered from 1 to 8.

       

      Thanks in advance.