+ Reply to Thread
Results 1 to 4 of 4

If multiple criteria are met in sheet 1 then paste in Sheet 2 if the dates coincide

Hybrid View

Alex92 If multiple criteria are met... 03-17-2018, 07:20 AM
JohnTopley Re: If multiple criteria are... 03-17-2018, 08:36 AM
Alex92 Re: If multiple criteria are... 03-17-2018, 08:43 AM
JohnTopley Re: If multiple criteria are... 03-17-2018, 08:48 AM
  1. #1
    Registered User
    Join Date
    03-17-2018
    Location
    London, England
    MS-Off Ver
    MS OFFICE 2013
    Posts
    2

    Re: If multiple criteria are met in sheet 1 then paste in Sheet 2 if the dates coincide

    That worked like a charm, thank you for your time, I will definitely play around with what you've given me and explore additional applications!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,705

    Re: If multiple criteria are met in sheet 1 then paste in Sheet 2 if the dates coincide

    You are very welcome.

    The formula I provided is a very frequently used one to extract data in "2 dimensions" (row and column) so it is worth understanding how it works.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Replies: 2
    Last Post: 01-23-2016, 01:16 PM
  2. Replies: 3
    Last Post: 10-28-2014, 09:53 AM
  3. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  4. One criteria between two dates on multiple sheet.
    By karnold in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 08:47 AM
  5. VBA cut from sheet 1 with multiple criteria onsheet 2,paste to next blank row sheet3
    By kevinsnewmatrix in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-06-2012, 02:03 PM
  6. Replies: 8
    Last Post: 08-08-2010, 06:10 AM
  7. Copy\Paste multiple criteria based rows to new sheet
    By namz in forum Excel Programming / VBA / Macros
    Replies: 46
    Last Post: 06-06-2008, 08:08 AM

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