Hi All,

I need some code that can look through all worksheets in my workbook and check if it is an active member, if it is get some information from that worksheet i.e. their birthday then update the birthdays worksheet with this information.

So to summarise I would like to press a button that will clear the birthdays worksheet, then look for all sheets with A2 marked as Active and get the name and DOB9.

This is for a charity project I’m working on.

Thanks in advance,
Dan