R
Robert Kettle
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.
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.