Results 1 to 5 of 5

Copy Visible Filters cells to other Visible and Filtered cells

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2019
    Location
    Los Angeles, CA
    MS-Off Ver
    2013
    Posts
    64

    Copy Visible Filters cells to other Visible and Filtered cells

    on the sheet that im attaching, i have data on SHEET 1 that i want to copy onto SHEET 2. SHEET 1 has test scores for 5 students, sheet 2 is missing 2. i want to FILTER John and Larrys score on Sheet 1, thereby only showing cells A6, B6, A8, B8. the copy over the "88" and "85", then head to Sheet 2, and filter out only for John and Larry. i highlight cells B6 and B8, go to Ctrl +G, select blanks, and paste over, and get an error. how do i accomplish this? thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 07-07-2020, 03:45 AM
  2. Copy-Paste formatting of visible cells to visible cells
    By hansaaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2018, 04:29 PM
  3. Copy Paste to visible cells only with different filters in different sheets / workbooks
    By EhcacommenceVBAhum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2017, 08:17 PM
  4. Copy visible cells only from filtered
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2015, 09:39 AM
  5. Copy Visible Cells Using Offset.Value in a Filtered Range
    By PreLives in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2014, 01:09 PM
  6. [SOLVED] Copy/Pasting Values from visible cells (using autofilter) to visible cells
    By evakotsi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 07:49 AM
  7. Copy Visible cells and paste values only to visible target cells
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2010, 04:09 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1