+ Reply to Thread
Results 1 to 3 of 3

Past Data in filtered and selected cells

  1. #1
    Registered User
    Join Date
    03-31-2015
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    17

    Past Data in filtered and selected cells

    Hi Experts;

    I want to copy some raw data from Sheet2 to Sheet1 like;

    in Sheet1 there is one column for name of colors.(Black, Blue, Green, Red)
    In Sheet2 there are some values for all colors. (Black, Blue, Green, Red)

    I want to past Sheet2 color values in Sheet1 before respected color names.

    if I filter Sheet1 for "Black" copy all values under "Black" from Sheet2 and past them on Sheet1 visible cell which are filtered for "Black".
    It does not put that values on filtered cells with color_name "Black".
    Past OR (Ctrl+v) put values in continuous cells.

    Sample file is attached!

    Thanks and Regards
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Past Data in filtered and selected cells

    Try this...
    On Sheet1,
    In C2
    Please Login or Register  to view this content.
    and copy down.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    03-31-2015
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    17

    Re: Past Data in filtered and selected cells

    Thanks sktneer,

    This formula is working fine for this sample sheet.
    Let me apply this on original sheet.

    I may bother you again for this issue please.

    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. Extracting filtered data selected using slicers and pivot tables
    By racundra in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-15-2016, 04:27 AM
  2. Copy filtered Data into another worksheet based on selected criteria
    By TheresaHartigan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2014, 09:39 AM
  3. Need to select and past data between two cells
    By chugerknot in forum Excel General
    Replies: 6
    Last Post: 11-04-2013, 03:43 PM
  4. [SOLVED] Cut & Past For Selected Range
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-26-2012, 11:03 AM
  5. copy data from selected cells , in selected row and paste it to ms word table ?
    By aaashaaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 03:25 PM
  6. from .txt to .xls how past data in seperate cells
    By NEWATTHIS in forum Excel General
    Replies: 2
    Last Post: 10-13-2006, 02:25 AM
  7. from .txt to .xls how past data in seperate cells
    By NEWATTHIS in forum Excel General
    Replies: 1
    Last Post: 10-08-2006, 01:34 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