Training spreadsheet

Hi all,

I'm a bit of an novice with excel, so i hope you guys can help.


I need to create an excel sheet to store information of all volunteers with our organisation. A question to all you Macro experts out there.

I am currently populating an excel sheet which looks something like the attachment. The problems are:

a) I need to filter out all individuals who have not had there training/crb check or it has expired. As you can see from the attachment, I have added basic formatting to highlight them. What I need to do is to somehow automatically filter them and populate the ones that need CRB or training renewel on to a new tab using a macro.

b) I have created a macro button, but when i press it, it just copies itself on to the other tab as opposed to the actual spreadsheet from sheet 1. (and theres no formatting involved, i was just testing it by trying to copy everything from the main table on to another tab)


So....

can anyone help me solve the above???...i have attached the excel sheet