+ Reply to Thread
Results 1 to 4 of 4

Google Sheets: copy cells from a column that only are adjacent to checkboxes

  1. 07-28-2022, 10:08 AM #1
    albermad
    albermad is offline
    Registered User
    Join Date
    07-28-2022
    Location
    Tampa, FL
    MS-Off Ver
    Google Sheets
    Posts
    1

    Exclamation Google Sheets: copy cells from a column that only are adjacent to checkboxes

    Hi! See image: So what I am trying to do is copy cells from the "Tasks and Responsibilities" column that are next to the boxes that are checked, and paste them into another sheet.

    For example: I want all of the tasks that are next to Dawn's checked boxes copied into the "Tasks DD" sheet, without any of the tasks are next to empty boxes, in order to make a separate sheet that only has Dawn's tasks listed. I know that I can do this manually if need be but I thought it would be cool to see if there was a formula for it.

    I don't want to cut them, I want the original sheet to stay intact.

    Thanks!
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 08-01-2022, 03:17 PM #2
    Estevaoba
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,259

    Re: Google Sheets: copy cells from a column that only are adjacent to checkboxes

    Hi, albermad. Welcome to the Excel Forum.
    Please follow instructions on yellow banner above to upload a sample workbook.
    Reply With QuoteRegister To Reply
  3. 08-01-2022, 04:00 PM #3
    janmorris
    janmorris is offline
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Google Sheets: copy cells from a column that only are adjacent to checkboxes

    Hi albermad,

    since Google Sheets checkboxes work completely different to those of excel, and sharing an excel file would then require a rebuild of your document, can you please post a link that has been broken up to replace the dots with (dot), and without the https:// prefix.

    then i can take a look at the actual file and create the formulas you need.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
    Reply With QuoteRegister To Reply
  4. 08-01-2022, 07:38 PM #4
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Google Sheets: copy cells from a column that only are adjacent to checkboxes

    Quote Originally Posted by Estevaoba View Post
    Please follow instructions on yellow banner above to upload a sample workbook.
    Google Sheets is web only so we will need a link rather than an upload.

    Quote Originally Posted by janmorris View Post
    please post a link that has been broken up to replace the dots with (dot), and without the https:// prefix.
    We do not allow new user to post live links, so you will have to follow janmorris's suggestion to provide a URL that will not be live.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google SHeets: Count Checked checkboxes in filtered data of google sheet
    By Faizan Naseem in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 07-07-2022, 05:42 AM
  2. Find max value related to adjacent column - Google Sheets.
    By nick00 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2022, 10:57 PM
  3. Google Sheets: IF Formula with Checkboxes and Strings
    By SquirrelousLester in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 11-03-2021, 10:11 AM
  4. (Google App Scripts) Copy and paste value for all Google Sheets contained in one folder
    By bobbiekan in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-29-2021, 11:48 PM
  5. VBA Macro needed to match Column to Column and copy/paste adjacent cells
    By catscats11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2019, 02:16 PM
  6. If column contains a value copy adjacent cells
    By Graham987 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2012, 06:44 AM
  7. Copy cells to adjacent column, removing blanks
    By jbitluk in forum Excel General
    Replies: 8
    Last Post: 12-11-2009, 03:14 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1