I'm going to show you how to show and
hide rows with use of a check box
without the use of a macro so here we
have the most basic list I could think
of and so this would be the possible
items that you would buy on your grocery
list and what from this list and with
the check box we're going to create a
shopping list so what I did is I
selected the top item from my from my on
my second cheat on my shopping sheet I
selected the top item from the items and
press ENTER and it's linked so that each
each of the items are reflected on each
of the items are inflected on both pages
and so now what i've done is i put a
checkbox next to it so what I've created
is checkboxes next to the items and on
the shopping list there is a true next
the items that I need so what we're
going to do is I'm going to show you how
I did this so I'm going to go in the
next to the bread item here i'm going to
click on the cell beside it i'm going to
go to my Developer tab go to the tool
tool box here click on it and I'm going
to click the check box from the form
controls now i'm going to press my alt
key down click in my cell and you get a
check box now i don't need any text here
so i'm going to just delete this and so
now what I'm going to do is I can click
away and then i'm going to right click
on this and i'm going to select format
controls okay so let's click in here and
let's click on little red arrow to
minimize our dialog box let's go to our
shopping list let's go next to the bread
and click there and we'll click our
little red arrow again and we'll say
okay so if we if we click this we go to
the shopping list then
we'll have a true next to bread to get
just the items that we need we're going
to go to the art we have an automatic
filter from the data from the data here
we click on our top item we click on the
automatic filter and we're going to drop
down and we are going to just select
we're going to just select the true
items and so there you have the list
that you've checked the milk butter
bread true now but we need the heading
for bakery here so let's show you how I
did that so I'm going to click and show
all the items and now what I've done I
have selected all the cells next to the
bakery and i have named it in the name
box I've named it bake so if I've got
any items selected in here I would like
the heading to show so what I'm going to
do is I'm going to do a formula in here
and i'm going to do count if so equals
count if and will do opening brackets
and we'll we'll select our range that
we've named which is baked and you can
see it on the list here so we're going
to double click that and when you say if
any of these equals true so we'll type
in true here now if there's any more
than 0 throughs in here I want you to
show the heading so we'll go greater
than 0 and press Enter so now they
create because bread has been selected
the bakery heading has been has been
displayed so now we can once again go to
our drop-down list for our filter select
true and there we go there we have all
our items including our headings in our
list please subscribe