Results 1 to 4 of 4

Copy cells from another sheet depending on date

Threaded View

  1. 06-26-2023, 12:26 PM #2
    tanasedn
    tanasedn is offline
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Copy cells from another sheet depending on date

    Hi,
    maybe something like:
    Formula: copy to clipboard 
    =LET(a,INDEX(Sheet2!$D$6:$AX$23,MATCH($C6,Sheet2!$C$6:$C$23,0),MATCH(Sheet1!D$5,Sheet2!$D$6:$AX$6,0)),IF(a=0,"",a))
    Attached Files Attached Files
    Diana Tanase

    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
    Reply With QuoteRegister To Reply
« 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 a range of cells to different sheet depending on which month
    By Steffidc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2021, 06:00 PM
  2. Copy cells into specific rows depending on value (Date) in column A
    By lewiem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2016, 09:45 AM
  3. Macro to copy & paste data into new sheet depending on column header (date)?
    By BobbyH89 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2015, 03:44 PM
  4. [SOLVED] Copy cells from each row into new sheet, depending on if statement
    By christopherL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-28-2013, 08:06 AM
  5. Copy cells from another sheet depending on category
    By Lemac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2013, 06:47 PM
  6. VBA Macro to copy cells to another sheet based on the date value
    By lilis_hlias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2012, 04:57 AM
  7. copy row depending on value to new sheet
    By jonpdavies@gmail.com in forum Excel General
    Replies: 5
    Last Post: 09-28-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1