Question regarding the making of a selection in a certain column a

G

Guest

Hi,

I have a question regarding the making of a selection in a certain column
and exporting data based on that selection to another sheet in excel. I will
split up my question in two parts:

1:

In a column I would like the option to choose Yes/No. How do I do this? I
found out that you can use checkboxes but I really want Yes/No to appear in
the cell.

2.

From the cells that have a "No" in it, I would like to export certain cells
in the same row to another excelsheet. Besides this I would like to be able
to count the No's and Yes's.

Would really appreciate some help!

Tommie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas 2
Count yes against name 1
Finding certain value in a column 2
Formula for Multiple "IF's" or maybe "COUNTIF's"??? 7
division with blank cells 5
Characters in logical calculations 1
Excel A CountIF question... I think 2
Can Vba workout if a selection is part of a group? 0

Top