how to print cells based on "Yes".

F

Francis Knight

If the first cell in row 1 of Column "A" is "Yes", how do I get preselected
contiguous or non contiguous cells in the same row to print? If the answer is
"no", I do not want cells in that row to print.


Thanks for anyones help!

Francis Knight
 
R

Ron de Bruin

Hi Francis

You can use Data>AutoFilter to filter on that column and print.
Only the visible cells will print
 

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

Newbie Help - IF Yes No Function 0
Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
Split cells next to 1 cell 1
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top