Is this the right forum for this question?
I would like to print a list of members based on a value in another column B C D based on a value of 1 print name on report.
report B would contain
Allen
Carol
Dave
report C would contain
Bob
Dave
Ed
report D would contain
Allen
Carol
Ed
A B C D
NAME MON TUES WED
Allen 1 0 1
Bob 0 1 0
Carol 1 0 1
Dave 1 1 0
Ed 0 1 1
Last edited by newtoecel; 09-24-2011 at 11:06 PM.
activate the autofilter on your data, then select to show only the 1 on column B and your list will be as you want. You can now print it. Change the filter of column B, C or D to suit your needs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks