Macro help

PatmanJon

New Member
Joined
May 19, 2021
Messages
1
Office Version
  1. 2010
Platform
  1. Windows
Hi,

I am looking for a macro to help me filter some data based on training compliance. It will be for a number of people.
I will attach the spreadsheet and have changed the names and training info to protect identify with numbers (I hope this doesn't make it more difficult?
Names would be put along the top and training dates underneath. Between each name is a hidden column which indicates training out of date (would also appreciate any ideas on how to improve this too if possible) but I want to be able to collate the data based on each individual and what training is outstanding and put to a 'summary sheet'. The current summary sheet only give the number of training outstanding but not detailed info.

I hope I make sense but if not, please let me know and I will try answer questions.

I apologise that the picture is not too clear.

Any help greatly appreciated.

Jon
 

Attachments

  • 1.png
    1.png
    64.6 KB · Views: 10

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
4,299
You pic is way too small to discern anything.

It is best to provide a workbook of same. You will need to use a web based cloud site then provide the URL download link here as this Forum does not permit
the attachment of workbooks.
 

Forum statistics

Threads
1,147,633
Messages
5,742,235
Members
423,716
Latest member
melpotter22

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top