+ Reply to Thread
Results 1 to 2 of 2

Copy non-adjacent cells, paste without blanks (based on only one column)

  1. #1
    Registered User
    Join Date
    05-08-2018
    Location
    Netherlands
    MS-Off Ver
    MS 2013
    Posts
    15

    Copy non-adjacent cells, paste without blanks (based on only one column)

    Hi all,
    I have a table (G14:I60), I want to filter to find all cells in I60 with text, then copy the filtered table (G:I) to the bottom of another sheet (IE take all actions from today's meeting agenda with some topics having no actions, and make a summary list of only actions). There are also values below row 60 which I want to ignore for the whole process (i.e. not filter, not copy).
    What I have is the below - The only step I can't get is copying 3 columns (G,H,I) not just Column I.
    I had it working by filtering range G14:I60, but some notes in G were "No action needed", so I want to filter only by I (Due date) as these are true actions.
    Any help?
    Thanks

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    05-08-2018
    Location
    Netherlands
    MS-Off Ver
    MS 2013
    Posts
    15

    Re: Copy non-adjacent cells, paste without blanks (based on only one column)

    Solved!

    Please Login or Register  to view this content.

+ 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. Replies: 14
    Last Post: 10-29-2015, 07:29 PM
  2. [SOLVED] Copy and paste random cells values from a range to another sheet column with no blanks
    By macquhele in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2015, 06:05 PM
  3. Replies: 7
    Last Post: 10-26-2014, 06:01 PM
  4. [SOLVED] How to copy/paste column, only cells with values (non-blanks)
    By ChristopherH in forum Excel General
    Replies: 5
    Last Post: 02-03-2014, 03:14 PM
  5. [SOLVED] Copy/Paste Adjacent Cells based on ActiveCell
    By brgr4u in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-24-2013, 03:41 PM
  6. Copy cells to adjacent column, removing blanks
    By jbitluk in forum Excel General
    Replies: 8
    Last Post: 12-11-2009, 03:14 PM
  7. Removing cells based on adjacent blanks
    By F6Hawk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2007, 08:17 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