Meeting Actions Tracker

[LORPete]

Hello.

I'm trying to create a dashboard to pull overdue meeting actions from several work sheets (meeting minutes and actions) in to one clear worksheet to highlight the overdue tasks. I've tried a few methods but can't seem to get it to work.
In each meeting minutes work sheet, I have tick if complete or cross if open. I want to copy over the row of information of the cross is present. I've attached a screen grab to help understand.

[maniacb]

What you are looking for is possible, but would be hard to implement without a sample file. See yellow banner above.

[LORPete]

Attached sample workbook

[maniacb]

Here is some working code, but you have to remove all merged cells for it to work

Please Login or Register  to view this content.

[maniacb]

Here is the file with the code posted above.

[LORPete]

Thank you for this. When I run the code, there seems to be an error. Is that something at my end?

[maniacb]

Can you tell me what line gets highlighted after the error?

[LORPete]

It seemed to be
For J = Sr To Step -1

I did a bit of digging and I thought it was because J wasn't defined. I swapped it for x which was defined and it seemed to work. I'm a total amateur, so that might not have been the right thing to do.

I have a follow up question to this also. If I had more worksheet in here, but wanted to ignore them in the code, can this be done?

Thank you for your help so far

[maniacb]

Yes, just make sure the sheet name has an underscore “ _” in the name. I coded for that eventuality.

[maniacb]

Here is the corrected code for the j issue, j really should be a number.

Please Login or Register  to view this content.