View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnson Johnson is offline
external usenet poster
 
Posts: 8
Default How do I coppy a range from 1 sheet to another via IF statement

In sheet 1 colom A to N I made some formulas.
In colom O I need a condition to be entered , either a Y or a N ( Yes or No ).
In sheet 2 I want to use an if statement to coppy range A to N from sheet 1,
if the condition is Y in the if statement.

I need to do this for a number of rows

The purpose of this program is to make a printable coppy on sheet 2 of all
the items that I chose in sheet one.


I use office XP pro