ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   printing certain rows (https://www.excelbanter.com/excel-discussion-misc-queries/94860-printing-certain-rows.html)

pbell419

printing certain rows
 

i want to print certain rows if a column has either a true or a false in
it. if the column has true, than i want it to print it. false would not
be printed. i am totally clueless on how to do this..


--
pbell419
------------------------------------------------------------------------
pbell419's Profile: http://www.excelforum.com/member.php...o&userid=35580
View this thread: http://www.excelforum.com/showthread...hreadid=553466


Gord Dibben

printing certain rows
 

Try using DataFilterAutofilter and when you filter out the Falses, print
what's visible.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 20:21:30 -0500, pbell419
wrote:


i want to print certain rows if a column has either a true or a false in
it. if the column has true, than i want it to print it. false would not
be printed. i am totally clueless on how to do this..




All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com