Missing Dates

Originally Posted by mrsmirf

I have a worksheet with 226749 rows of data extracted from a database. The table has many different Column Titles which includes Name, From Date, To Date, Etc. The issue is that this data is missing dates sometimes.

From Date	To Date
11/01/2012	11/30/2012
10/01/2012	10/31/2012
07/01/2012	07/31/2012

I need a way to find out what names are missing what dates. Any suggestions. Remember there are tons of names, and the table above is already filtered to one of the names. I need to be able to do this without going through every name. Because there are like 40,000. Thank you.

Could you post a file indicating your data layout and what missing/non-missingdates are to included where?

All I glean from you above is that you may be missing the dates between 11/1/2012 and 11/30/2012, etc. If so why don't you just fill them in. Excel makes that easy.

If you want some VBA, which is understandable for that many rows, that's OK, but should be clearer just what you want it to do, and where.

Kalak,

I would post what I am working with but it is all confidential. I have even changed the titles as to not give to out too much information.
But to answer you question. It is not only the dates missing as in the example above. Different names have different dates missing.

I think this will work I will give it a try: http://www.excelforum.com/excel-programming-vba-macros/861184-find-and-add-missing-dates-autofill-the-newly-added-rows-save-as-csv-comma-delimited.html

Have you tried the autofilter menu options?

Thanks for the reply.

Have you tried the autofilter menu options?

I am going to.
I am writing the code so that it will auto filter to each name, then insert appropriate rows where there are missing dates. Then once that does its thing. I will just filter to only show "missing" -which I will also insert in column C for every newly inserted row.

If anyone has any better ideas let me know.