S
sambles28
A little redundant but maybe someone can help me a little further. I am
trying to write an excel spread sheet to order products for jobs that I
send my employees out on. For example, I own an air conditioning
company and we use thousands of products for lots of different jobs. I
want to put something together so that I can just go onto my computer
and put a check mark next to the product that I'd like to order. The
tricky part is that I only want the items with a checkmark to print
out. So I basically want the spread sheet to thin down to a few pages
max versus listing all of the stuff that I am not ordering for the
particular job. For example...below I will use a capital letter to
show each column. And I will use an X in place of a check mark.
Column A will represent the check mark which I do not know how to set
up in excel either. Column B will be the item description, and column
C-the quantity.
A B C
X 3" Elbow 6
4" Elbow
X 5" Elbow 4
X 6" Elbow 2
7" Elbow
8" Elbow
X 9" Elbow 5
Now, how do I set up column A to just use the mouse to be able to put a
check mark, and then only print the 3", 5", 6", and 9" and not print the
rest that do not have a check mark next to it. Do I need to save it as
a web page or something. I've noticed how on web pages you can go in
and click a check mark into certain boxes. Is that even possible to
set something like this up in excel. Any detailed information would be
very helpful!
Sam
trying to write an excel spread sheet to order products for jobs that I
send my employees out on. For example, I own an air conditioning
company and we use thousands of products for lots of different jobs. I
want to put something together so that I can just go onto my computer
and put a check mark next to the product that I'd like to order. The
tricky part is that I only want the items with a checkmark to print
out. So I basically want the spread sheet to thin down to a few pages
max versus listing all of the stuff that I am not ordering for the
particular job. For example...below I will use a capital letter to
show each column. And I will use an X in place of a check mark.
Column A will represent the check mark which I do not know how to set
up in excel either. Column B will be the item description, and column
C-the quantity.
A B C
X 3" Elbow 6
4" Elbow
X 5" Elbow 4
X 6" Elbow 2
7" Elbow
8" Elbow
X 9" Elbow 5
Now, how do I set up column A to just use the mouse to be able to put a
check mark, and then only print the 3", 5", 6", and 9" and not print the
rest that do not have a check mark next to it. Do I need to save it as
a web page or something. I've noticed how on web pages you can go in
and click a check mark into certain boxes. Is that even possible to
set something like this up in excel. Any detailed information would be
very helpful!
Sam