Basically, you would use a for/each loop. Let's assume you have col A with
name and col B with an "x" to indicate active.

for each person in range("a2:a22")
if person.offset(,1)="x" then
'do something such as
sheets(person).printout
end if
next person

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Scott Smith" <Scott wrote in message
...
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?