+ Reply to Thread
Results 1 to 3 of 3

VBA to Auto Import a worksheet from one workbook to another

  1. #1
    Forum Contributor
    Join Date
    12-11-2014
    Location
    Missouri
    MS-Off Ver
    2016
    Posts
    153

    VBA to Auto Import a worksheet from one workbook to another

    Hello,
    I have a workbook which we use daily to import invoices to Quickbooks. In that workbook we have an Invoice worksheet and a Draft worksheet. We currently do a manual import on each of those sheets from a sheet in other workbooks which we receive multiple times a week and reside in a specific directory. One of the Workbooks we receive contains worksheet 1 which is a draft. That workbook is named with the following(EFT Draft for 1000150 - 20180227 - ($207.49). The other workbook contains worksheet 1 which is an invoice and that workbook is named with the following(Sales Invoice 0347918 for 1000150 - 20180109). Keep in mind that these workbooks are titled differently every time we receive one.

    What I have in mind is a popup dialog box where we could type a piece of information from the workbook title such as $207.49 for example and it would be search the directory and then populate the Draft worksheet or 0347918 and it would search the directory and populate the Invoice sheet.

    I have no idea where to start on this as my vba skills are very basic to non existent.

    Thanks in advance,
    Dean

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: VBA to Auto Import a worksheet from one workbook to another

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    12-11-2014
    Location
    Missouri
    MS-Off Ver
    2016
    Posts
    153

    Re: VBA to Auto Import a worksheet from one workbook to another

    Here you go! Currently the way we populate the draft and invoice worksheets in the Fuel Invoice Auto Import workbook is by using the "Get Data" function
    , selecting the appropriate workbook, worksheet 1, selecting "Close & Load to" and selecting the "Existing Worksheet". In this case the files we are searching
    will be in "F:\Salem\Salem Drafts & Invoices\2018" and going forward will change to "F:\Salem\Salem Drafts & Invoices\2019".

    Also, there are other macros and several Vlookup functions as well as some array formulas in the Fuel Invoice Auto Import workbook

    Thanks,
    Dean
    Last edited by dgarber; 12-31-2018 at 03:07 PM.

+ 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. Import Worksheet From Another Workbook
    By dgarber in forum Excel General
    Replies: 3
    Last Post: 12-31-2018, 12:51 PM
  2. Import worksheet from another workbook
    By MrWhiskey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-24-2017, 02:03 PM
  3. [SOLVED] Import from 2nd workbook to specific worksheet
    By ERoemer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2013, 03:15 PM
  4. Import workbook as worksheet in the active workbook
    By legendkiller420 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2010, 06:07 AM
  5. import worksheet into workbook
    By daz18983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2010, 04:50 PM
  6. Import worksheet from different workbook in current workbook (URGENT)
    By IntosH in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2009, 07:56 AM
  7. How do I import an XLT worksheet into another workbook?
    By chris5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2005, 08:05 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