+ Reply to Thread
Results 1 to 2 of 2

Using Match/Index in macros

  1. #1
    Registered User
    Join Date
    01-06-2020
    Location
    London, England
    MS-Off Ver
    16 MS Office
    Posts
    1

    Question Using Match/Index in macros

    Hello, everyone

    I am trying to compare 2 sheets and get the information of a specific column, and paste that information from one sheet to another. Problem is that date isn't formatted correctly so I tried to filter it with Day/Month/Year command, for some reason my code doesn't work. Perhaps I did something wrong. It is my first time dealing with macros, usually I only did formulas in the sheet. But since it's an array formula it is really tedious to apply formula to every cell separately.

    Below is my macro code.

    Please Login or Register  to view this content.
    Last edited by Apple_sin; 03-19-2020 at 11:15 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Using Match/Index in macros

    Welcome to the forum.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
    Best Regards,

    Kaper

+ 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. Picture lookup using INDEX,MATCH,MACROS, VLOOKUP
    By Princessweneki in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2017, 12:21 AM
  2. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  3. Macros Min, Index & Match Formula
    By Aussibuilder50000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2016, 11:36 PM
  4. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  5. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  6. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  7. [SOLVED] Help with VBA/Macros using Index/Match Function
    By BamBamMoneyBags in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-08-2013, 01:13 PM

Tags for this Thread

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