+ Reply to Thread
Results 1 to 4 of 4

copy data from sheet to another based on cell value

  1. 11-28-2020, 12:42 AM #1
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    copy data from sheet to another based on cell value

    hello i have data in sheet 2 , sheet3 in sheet 3 cell value d2 is the search based on col o in sheet2 then it bring data i put the result in sheet 3 after i fill in d2 what supposes being in sheet3
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-28-2020, 01:43 AM #2
    Croweater
    Croweater is offline
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: copy data from sheet to another based on cell value

    Try something like this...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 11-28-2020, 02:49 AM #3
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,517

    Re: copy data from sheet to another based on cell value

    To Sheet3 code module
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by jindon; 11-28-2020 at 03:01 AM.
    Reply With QuoteRegister To Reply
  4. 11-28-2020, 03:07 AM #4
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: copy data from sheet to another based on cell value

    Thanks for you're both , your codes work
    Last edited by ABDELFATTA; 11-28-2020 at 03:09 AM.
    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 to a new sheet based on cell value
    By vasu_james in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2019, 05:35 PM
  2. Copy lines from data to sheet based on cell value
    By Jamesraywebber85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-09-2018, 03:42 PM
  3. Need to copy the data into new sheet with cell based file name.
    By anwitha in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-30-2018, 01:40 AM
  4. [SOLVED] Copy paste data one to multiple sheet based on cell value to sheet name
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2015, 12:54 AM
  5. [SOLVED] Need to Copy cells data to a new sheet based on value of another cell
    By clintandcaden in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-14-2012, 05:28 PM
  6. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  7. How to copy data from a sheet based on a cell value?
    By Bill Williams in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2011, 01:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1