Training spreadsheet

[help-needed]

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

[Bob Phillips]

Please Login or Register  to view this content.

[jraj1106]

Hi

I hope this is what you wanted... Check it out...

macro practice.xlsm

[help-needed]

Hi,

That is absolutely amazing!!!

Thank you ever so much for the quick reply…I though I would have to wait weeks!!!

Can I be a pain and throw a few more spanners in the works?

I have attached my final excel sheet in terms of how I would like it to be (as opposed to the other one which was a first attempt)

How would I:

a) Some how use the macro to copy the relevant tabs (as in personal details & course details in to the “course details” tab and personal details & CRB details in to the “CRB details” tab) and to finally extract the expired data in to the final tab (“expiries”) as you did with the last worksheet?

I am so greatful for this, honestly!

[help-needed]

Hi

I hope this is what you wanted... Check it out...

Attachment 154763

Hi Raj,

i couldn't do anything with the sheet you posted.

its okay though, Bob's code worked perfectly. I hope either of you can help with the above post as I have complicated things slightly! I need this for a spreadsheet I’m producing for volunteers.

Cheers in advvance to both of you guys,

Sham