+ Reply to Thread
Results 1 to 5 of 5

How to selectively copy the content of some cells without empty cells

  1. #1
    Registered User
    Join Date
    01-15-2020
    Location
    Teddington, UK
    MS-Off Ver
    Online Google Calc
    Posts
    2

    How to selectively copy the content of some cells without empty cells

    Hi,

    I'm using the online Google drive Excel/Calc which in my experience works just like MS Excel.

    Also I'm guessing my question must have been asked/answered in the past by someone else but I couldn't figure what to type to search for it, so apologies for that.

    This is my table now:
    Capturfe.PNG


    In a new table(on another page) I would like to list/copy all and only the "Transactions" (without copying the "Buy-in"). I would like to do so without having empty cells in the new list. So I would like my new table to look like:
    Captuddrfe.PNG


    Thanks a lot for your help,
    Regards,
    Thomas
    Last edited by thomasboivin; 01-17-2020 at 09:31 AM.

  2. #2
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: How to selectively copy the content of some cells without empty cells

    Hi,

    Follow the below steps:
    1 Click on Data on the menu bar, then select filter
    2.Click on the Type cell and select Transaction
    3. This would give you the opportunity to get the filtered data.you

    For future, you can google it before posting. These easy tutorials are available on youtube.
    Thank You

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: How to selectively copy the content of some cells without empty cells

    If you're doing it in Google Sheets, a simple FILTER function will suffice.
    Rory

  4. #4
    Registered User
    Join Date
    01-15-2020
    Location
    Teddington, UK
    MS-Off Ver
    Online Google Calc
    Posts
    2

    Re: How to selectively copy the content of some cells without empty cells

    Thank you, appreciate the answer.

  5. #5
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: How to selectively copy the content of some cells without empty cells

    Hi Mark the thread as Solved, and Hit * Add Reputation to say 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. Replies: 3
    Last Post: 12-25-2018, 02:34 AM
  2. Automatically copy cells content based on the content of another cell.
    By chrisbarlow1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 11:13 AM
  3. Replies: 2
    Last Post: 09-06-2012, 07:55 PM
  4. Replies: 3
    Last Post: 06-28-2012, 09:05 AM
  5. [SOLVED] Fill empty cells with content of full cells above it
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2011, 03:57 PM
  6. Macro to selectively copy cells from excel.
    By Venkat89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2011, 11:31 AM
  7. moving content into empty cells
    By ned1234 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-09-2011, 10:45 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