+ Reply to Thread
Results 1 to 2 of 2

Table Value Lookup and copying like VLookup or Index Match

  1. #1
    Registered User
    Join Date
    12-08-2017
    Location
    Minneapolis, MN
    MS-Off Ver
    Standard 2013
    Posts
    83

    Table Value Lookup and copying like VLookup or Index Match

    Hi,

    I would LOVE any help anyone can give in this area. This would be hugely appreciated. Sorry if the description is long. This macro would save tons of time and monotony at work.

    Essentially, I want to make a Word VBA macro that functions kind of like an excel VLookup or index match, between open documents. Is this possible? I don't need the entire code, just some critical tips and directions for getting started. See the attached picture for reference.


    Basically I will have two word documents open- the active file and the one to copy from, from another audit binder.

    We basically have to do a lot of audit checklists on Word tables. We basically have to add references or notes in the last column and sign off in the 2nd to last column. I am interested in automating the copying of references/notes from one document to the other in the cases where the descriptions (column 3) in old document match the descriptions in new document. They will generally be the same and this will save the team lots of time and boredom. In other words somthing like vlookup or index match. For more detail, the workpapers (Audit Programs) come from a vendor and they're 95% percent the same each year and 90% the same each engagement depending on selection criteria (is it a first year audit? Are we doing extended procedures given higher risk, or just doing basic procedures). In other words, for each workpaper, most rows and columns are identical with prior year and other binders, and same with the references as the layout of our binder is the same. 1400s are always trial balances, 7000s are always board minutes. We need at least one audit program for each audit area (e.g. planning, cash, accounts receivable, inventory) for each client engagement so that's a lot of copying and pasting. Review will be done before sign off of course but they will be 90% the same and it will save time copying and looking things up.

    The match in C3 doesn't have to be 100% identical as long as one would know it is referring to the same point of principle (for example if they added a comma or a trailing space or even if they changed a few key words), but I suspect generally they will be 100% the same as they probably won't get touched by the editors if there is no difference. Anyway we can cross that bridge when we get there.

    So where I'm at: I'm learning to work with Word VBA. I know how to use dictionaries in excel as well as regex, if that helps.

    Thank you so much!

    Annotation 2020-01-16 103439_LI (2).jpg

  2. #2
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Table Value Lookup and copying like VLookup or Index Match

    I think you could "locate" and refer to the table if you bookmark it to, let's say Table1.
    Then in VBA use something like:
    Please Login or Register  to view this content.
    Maybe check one of these sources on how to search word tables:
    https://stackoverflow.com/a/46859782
    https://www.datanumen.com/blogs/3-qu...t-word-tables/
    To show your appreciation
    Click ★ Add reputation!

+ 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. Problems trying to match criteria in lookup queries
    By marisco in forum Excel General
    Replies: 5
    Last Post: 08-14-2019, 10:01 AM
  2. [SOLVED] Index Match Match for a small table lookup
    By slvrbktom in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 09-05-2018, 06:08 PM
  3. [SOLVED] Index and match in lookup table
    By Samantha McNeill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2016, 07:35 PM
  4. Table Lookup/Index Match Help
    By mustangsally in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-21-2015, 06:29 PM
  5. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  6. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  7. Index / Match / Lookup / VLookup / ??? Need Help
    By sslack in forum Excel General
    Replies: 2
    Last Post: 01-31-2005, 04:18 PM

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