Results 1 to 4 of 4

Changes in Row/Column trigger "Match Row and Column Value"

Threaded View

jp16 Changes in Row/Column trigger... 05-15-2018, 01:31 AM
jp16 Re: Changes in Row/Column... 05-15-2018, 04:01 AM
jp16 Re: Changes in Row/Column... 05-15-2018, 06:36 AM
jp16 Re: Changes in Row/Column... 05-15-2018, 12:56 PM
  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Changes in Row/Column trigger "Match Row and Column Value"

    Hi, attached a sample. My Sheet1 is the data sheet where the Match lookup range is (Row 1 and Column A). Sheet2 is where the Report is generated. I want to trigger the marco wheneevr Sheet2 Row 1 or Column A is change. The marco shall match the value in the Row and column from Sheet1 (lets say the Mary A), Then Sheet1.C2 value will be shown in H2 of Sheet2.

    Of coz, in Row1/ColumnA of sheet2, there will be other value where the match will produce error. Wheenever there is error, the marco shall look at the next value.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 07-16-2017, 09:06 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. [SOLVED] if cell in column in active row = "Y" ,trigger Macro.
    By Sircool1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2016, 05:15 AM
  4. Replies: 1
    Last Post: 08-20-2016, 01:59 AM
  5. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  6. Replies: 0
    Last Post: 07-09-2009, 04:07 PM
  7. [SOLVED] [SOLVED] Trigger "Worksheet_Change" for specific column?
    By Florence in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-26-2005, 03:52 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