+ Reply to Thread
Results 1 to 2 of 2

Match Criteria on Two Sheets and Transfer Values

  1. #1
    Forum Contributor
    Join Date
    06-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    213

    Match Criteria on Two Sheets and Transfer Values

    Hello, I need help creating the following Macro. I have Two Sheets the first Sheet is "Test3" that has the raw data from an export. Previous macros go through it and highlight rows based on a value.(Either Yellow or Red) What I'm trying to do is update the Sheet called "Trial". The first thing it will do is on the Test3 sheet it will find search Column A to see if the cell has a color in it. If it does then it will see if that File Number in Column A matches any file number found in Column A on the Trial Sheet. If no match is found it will create a new section with the day's current date and paste the necessary information in from Test3 to Trial.

    If a match is found for the file number it will take the information already on the Trial sheet and shift it to the top under the new section that was made.
    After that for that file it will Check Column D and see if it matches the Date from Column F on Test3 sheet. If it does match then it will Check to see Column F on the Trial Sheets Date has passed. If the date has passed it will mark Column G as Yes.

    I know this sounds confusing but if you look at the file and look at the Sheet called "What it should look like" it will make a lot more sense. Thanks for your help.

    TestBook.xlsx

  2. #2
    Forum Contributor
    Join Date
    06-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    213

    Re: Match Criteria on Two Sheets and Transfer Values

    Any ideas?

+ 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] Need Help..Match A Cell Values and Transfer to Different Sheets
    By trevor2524 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2014, 03:20 PM
  2. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM
  3. [SOLVED] Match between 2 sheets, highlight and transfer to new sheet
    By Narasimharao Nandula in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-28-2013, 09:51 PM
  4. Transfer data between sheets, validating 2 criteria.
    By Chris! in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2013, 10:11 PM
  5. Macro to transfer row of data between sheets based on certain criteria.
    By kmc86 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2012, 10:40 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