Search for due/overdue dates

Hello!

Being that I am not well versed in coding, I'm looking for assistance.

I need a macro that will search all rows and 1 column across multiple sheets--2 through 13 in this case--for dates that are within 30 days and those that are less than zero days, then copy those rows to sheet 1. Mind you, the dates are produced through formulas, if that makes any difference. This will also help me understand how to properly write these types of macros. I can't attach the excel as it is on a work computer, so if anyone needs any more details, please let me know. Thank you for any and all help, in advance!

I'm aware of that. The document cannot be posted from my work computer, as it is a disabled feature.

nobody is going to second guess the structure of your workbook - that requires a very powerful crystal ball
help us to help you - we do not need the ACTUAL workbook - just a replica with dummy info but with actual structure.
otherwise this could be a long and drawn out guessing game for those that get involved.
torachan.

I'm very sorry, I misunderstood. x_x Took a little guessing, but I'm sure it's very similar to this. Except for longer columns,
certainly. As you will see, some of the dates are yellow (due within 30 days) and red (overdue). I need those dates from all
the other sheets to populate as a list on the "Sorted" sheet, at the click of a button.

On a separate note, what did you guys use to learn this?

Am I missing the point ? - the data appears to be the same in all 12 sheets ???
I presume 12 sheets equate to 12 months but I cannot see the purpose to justify the effort.

Separate note, Perseverance & lots of time.

What you see is a very watered down duplicate. The original has the same number of sheets with 200+ rows per. Each sheet tracks a different element of my job.
It may seem rather moot, but I cannot stress how huge of a help that macro would be for the range of information that we have.

Sorry for the wait. I tried your command and received this error:

I'll return with results. Thank you!

As you probably already know, it worked perfectly in the sample. However, when I attempt to apply it to the original,
it tells me to debug the line "If cl.Value <= 30 + Date Then." I imagine this may be unique to whatever extra is in
the original so I've attached it, excluding sensitive information.

It succeeded in moving some of the items, just not all. I cannot figure out where/how it failed. The modified code is
included in the doc.

Here is the updated code. The hidden column I and formula errors in J had not been accounted for. Should be good to go. Let us know

Please Login or Register  to view this content.

Ever just feel dense, sometimes? I showed this to my supervisor and she reminded me that the blue sheets are tracked based on "PASS/FAIL."
My plan is to have them appear in the J column, as well. With that, would be easier for you modify the code yourself or to just tell me how to do
it? This would be the last change in parameters, but I don't want to take too much of your time, and I am more than willing to learn.

Edit: Save for my blunder, your code worked perfectly and I deeply appreciate it! Thank you so much!

No problem on the assist. But I'm unsure of your new requirement. In the blue sheets, you want to track something other than dates? Please explain how you want to see the code process the blue sheets.

I'll build the excel and post it, to make it clear.

Sorry for the delay. I put everything under "J," to make things easier; however, if it would be easier to have these under a different column, "H" would be ideal.

Is it the "incomplete" and the "not attempted" rows in the blue tabs that you want to show up in the slides tab?

What column do want to use to place the sheet name. The next one over?

I chose column L for you. Here is the code.

Please Login or Register  to view this content.

Exactly how I needed it. Thank you!

This has been extremely helpful! I cannot thank you enough!