+ 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. 03-17-2018, 08:43 AM #1
    Alex92 is offline
    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!
    Reply With QuoteRegister To Reply
  2. 03-17-2018, 08:48 AM #2
    JohnTopley is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy data from one sheet to another sheet multiple times based on criteria from one sheet
    By manojuasc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2016, 01:16 PM
  2. extract data between two dates from multiple sheets and paste all in one sheet
    By forquaidian in forum Excel - New Users/Basics
    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. Copy data from one sheet and paste to another based on multiple criteria
    By Hem in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1