+ Reply to Thread
Results 1 to 2 of 2

Matching values between two separate workbooks(Checklist)

  1. #1
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Lansing, Michigan
    MS-Off Ver
    2016
    Posts
    140

    Matching values between two separate workbooks(Checklist)

    The idea is that i'm doing a checklist(Workbook 2). On workbook 1 I have a macro where people select an item from a drop-down box (B2) and click a command button to send an email. What I want to do within the email macro, is call another macro that opens up workbook 2 and "checks off" ("x") the selected item from workbook 1. Workbook 2 has all of the possible items in column A while in column B is left for the check-offs. I cannot find anything on google to point me in the direction on how to execute this. I believe I'd be able to figure this out if I could just do it on a different sheet within workbook 1, but the workbook has to be a read-only file. Is there anyone that can help point me in the right direction? Thank you!

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Matching values between two separate workbooks(Checklist)

    You can create a macro to open workbook 2, find the relative record, then mark the record and close the file. If you provide sample files as per the yellow banner above we can assist further.

+ 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] How to highlight a row based on matching values from separate columns
    By MyStix01 in forum Excel General
    Replies: 2
    Last Post: 09-21-2017, 08:43 PM
  2. Replies: 7
    Last Post: 08-09-2016, 09:09 AM
  3. [SOLVED] Summing values matching same criteria on separate worksheets
    By Spritz in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-11-2013, 12:01 PM
  4. Matching separate worksheet and then subtracting their values
    By jimmihundreds in forum Excel General
    Replies: 4
    Last Post: 07-31-2013, 09:29 PM
  5. Replies: 8
    Last Post: 05-20-2011, 11:36 AM
  6. Replies: 1
    Last Post: 06-08-2009, 01:40 PM
  7. find a cell matching separate column and row values
    By LQEngineer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2006, 02:15 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