+ Reply to Thread
Results 1 to 2 of 2

Copy, Paste Data from/to non-filtered cells to filtered cells

  1. #1
    Forum Contributor
    Join Date
    Sri Lanka
    MS-Off Ver
    Excel 2016

    Question Copy, Paste Data from/to non-filtered cells to filtered cells

    Hi Experts,
    In my daily data entry work, I often happen to copy non-filtered data (from a different work sheet) and paste those to a filtered cells of a different work sheet. In other words, the same information in another work sheet has to be copied to a work sheet that has multiple information which can be filtered to match the copied information from the other work sheet.

    I tried to find a solution, but failed. I just installed Kutools also, but I don't know how to used it for this purpose.

    Is there a way through excel? or does Kutools have any option to do this?


  2. #2
    Administrator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit

    Re: Copy, Paste Data from/to non-filtered cells to filtered cells

    If you use Power Query to build the first filter and then add to the raw data, and then click on the refresh button, PQ should update the Query (filtered Data) appropriately. Click on the links in my signature regarding Power Query for further help.

    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Copy the filtered dates, do Formatting and paste it back to filtered column
    By Rajkumar_h in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-30-2017, 10:53 AM
  2. Copy from filtered cells and paste to another column
    By floxxie in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-07-2015, 07:19 AM
  3. Replies: 5
    Last Post: 08-09-2014, 07:55 AM
  4. Copy filtered cells and paste them in the same place - Header error
    By vpestana in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-31-2014, 10:56 AM
  5. [SOLVED] Avoiding Copy & Paste in Hidden/Filtered Cells
    By garrett.grillo in forum Excel General
    Replies: 5
    Last Post: 02-24-2014, 04:45 PM
  6. Copy and paste data with filtered cells
    By rikkyshh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2013, 06:54 AM
  7. Copy and Paste on Filtered cells
    By rlkerr in forum Excel General
    Replies: 2
    Last Post: 06-24-2009, 02:39 PM


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