Hello,

I need help writing a macro. I have a table with information about 30
people, some are active, some are inactive. Each person has a worksheet
assigned to them, and I have hyperlinks setup so once you click a person's
number, excel goes to their sheet, and there are hyperlinks within each sheet
to go back to the table.

So, I want a macro that will search my table, and for each active person, go
to their worksheet and print it.

I will also mention that my hope is I can then copy that macro and apply it
to a control button - to make it easier for my intended users of this file -
rather than having them run a macro.

Any suggestions?