Thank you. This worked for Google sheets as well, without using the True/False Column and using "true" for a checked box and selecting the checkbox column instead. Thanks for the help!
Thank you thank you thank youuuuu! Was searching for this answer for over an hour and could not find how to check a box and have it add up values. This is amazing and such a clear tutorial. Going to look real good at work when I share this when I show my boss! Haha
Thanks so much! No one ever adress the checkbox copy problem. It is first solution i See on YT. Very creative and easy. I hope maybe one day MS will improve auto copy for checkboxes in patch. Any way thanks
I have come back to this video so many times! However, this time I am coming back in hopes to find answers involving the macOS system. I don’t really see that here. How do I change this or what do I change exactly so that Excel can work properly on my new Mac as opposed to a Windows PC?
The code is in the workbook (link in description below). If the macros are not working then they have been blocked. I've got a video coming out shortly that addresses this.
Hi great Video, it came in handy for what i am doing. I do have a question though I am using this method in a table which auto updates getting the data from a sharepoint list, columns G-L are the only columns that get the data from sharepoint and I have the checkbox in row M (using the VBA Code) however when I update data, its ticking all the checkboxs on the table, do you know how I prevent this and get it to leave the checkboxes as they are when the table updates
I have a table with check boxes using your second method. I would like only the value of the checked cells to show in another column how do I get to do that I know there must be some link with the checked cell and the cell I want it to show but not sure how too. I have a total of 100 cells
I have a question. I’m working on one project and I don’t find the right formula for check boxes. Example: let’s take numbers from 1 to 20 and alocate 2 colours ( orange for odd and green for even ) and we have 4 results where need to stock data ( 1 to 10 = low / 11 to 20 high ) and we have box1 = low even green / box2 = low odd orange / box3 = high even green / box4 = high odd orange. When tick a box on number 1 for example, need in box1 = 1 but tick need to be gone after marking it and then let’s say we select 7, in box1 = 2 … sum and count formulas are not working unless I miss something. Is there any coding that needs to be ajusted ?
Hello, thank you for the videos. I used your Attendance tutorial and whend I paste formula into a Conditional formatting it did not work. Although it did work inside the spreadsheet itself showing True and False on weekdays. Formula I use was corresponding to yours: =OR(WEEKDAY(H$8,11)=6,WEEKDAY(H$8,11)=7,COUNTIF(Holidays_dates,H$8)=1,H$8=""). In my case it was H8. Please advised. Thank you.
Very very helpful! thanks a lot.
THANK YOU!!!!😇
Thank you. This worked for Google sheets as well, without using the True/False Column and using "true" for a checked box and selecting the checkbox column instead. Thanks for the help!
Thank you for your Tutorial Vid, it's so simple and easy to use.
Superb tutorial! Very clear and informative🤩
Thank you thank you thank youuuuu! Was searching for this answer for over an hour and could not find how to check a box and have it add up values. This is amazing and such a clear tutorial. Going to look real good at work when I share this when I show my boss! Haha
I really have to say thanks for your video, I had try a lot to find this to solve my problems.
Really helpful, thank you
Thanks so much! No one ever adress the checkbox copy problem. It is first solution i See on YT. Very creative and easy. I hope maybe one day MS will improve auto copy for checkboxes in patch. Any way thanks
You're welcome!
Great video. Excellent composition of the solution with the use of the CHAR function.
Glad you liked it!
there's this feeling of satisfaction on understanding formulas
Thank you so mcuh!
great lesson, thanks
thank you so much
Awesome!!!
Thanks!!
I have come back to this video so many times! However, this time I am coming back in hopes to find answers involving the macOS system. I don’t really see that here. How do I change this or what do I change exactly so that Excel can work properly on my new Mac as opposed to a Windows PC?
Thank you but VBA code is not in description and It is not working for me as I double click it still entering Edit mode
The code is in the workbook (link in description below). If the macros are not working then they have been blocked. I've got a video coming out shortly that addresses this.
Hi great Video, it came in handy for what i am doing. I do have a question though I am using this method in a table which auto updates getting the data from a sharepoint list, columns G-L are the only columns that get the data from sharepoint and I have the checkbox in row M (using the VBA Code) however when I update data, its ticking all the checkboxs on the table, do you know how I prevent this and get it to leave the checkboxes as they are when the table updates
Hey, the =char(254) does not work for me. Using Office365.. Any advice on this?
Have you checked the cell format to see if its set up as Text and not number etc
How can i make the chekbox activa with single click?
I have a table with check boxes using your second method. I would like only the value of the checked cells to show in another column how do I get to do that I know there must be some link with the checked cell and the cell I want it to show but not sure how too. I have a total of 100 cells
I have a question. I’m working on one project and I don’t find the right formula for check boxes. Example: let’s take numbers from 1 to 20 and alocate 2 colours ( orange for odd and green for even ) and we have 4 results where need to stock data ( 1 to 10 = low / 11 to 20 high ) and we have box1 = low even green / box2 = low odd orange / box3 = high even green / box4 = high odd orange. When tick a box on number 1 for example, need in box1 = 1 but tick need to be gone after marking it and then let’s say we select 7, in box1 = 2 … sum and count formulas are not working unless I miss something. Is there any coding that needs to be ajusted ?
I thought I had what I needed but I can't modify the file 😢
Hello, thank you for the videos. I used your Attendance tutorial and whend I paste formula into a Conditional formatting it did not work. Although it did work inside the spreadsheet itself showing True and False on weekdays. Formula I use was corresponding to yours: =OR(WEEKDAY(H$8,11)=6,WEEKDAY(H$8,11)=7,COUNTIF(Holidays_dates,H$8)=1,H$8=""). In my case it was H8. Please advised. Thank you.
Doesn't work on Mac as Char 254 in Windings provides different character :(
Please provide the code
why cant you do =COUNTIF(xx:xx,CHECKED)
thinks