View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Kettle Robert Kettle is offline
external usenet poster
 
Posts: 1
Default conditional copy macro

I am looking to set up a macro that will conditionally copy multiple cells
from one worksheet to another and print after each.

Example.

There are two worksheets DATA and REPORT.

For each occurence of TRUE in column A on the DATA worksheet, I want to copy
the corresponding value of column B to REPORT cell H2 (ie. A3=TRUE, copy B3 :
A10=TRUE, copy B10), then print the REPORT worksheet and repeat until all
TRUE rows from DATA have been printed.

Thanks for your help.