I have 2 columns "a" and "b"
in "a" they are either 0 or 1
in b are the worksheets I want to print ie Sheet2 Sheet3
I need a macro that goes down column a till it finds a 1 then goes to column b and prints out that worksheet and then returns and carries on untill it finds another 1 and prints the next one
in "a" they are either 0 or 1
in b are the worksheets I want to print ie Sheet2 Sheet3
I need a macro that goes down column a till it finds a 1 then goes to column b and prints out that worksheet and then returns and carries on untill it finds another 1 and prints the next one