Yeah, but it's the same amount of work to write the VBA code to run through millions of rows as twelve. Just takes longer to run afterward. And there are things you can do to keep even that from getting too unwieldy—or at least to reduce the run time considerably, but 3 million rows may take a while no matter how cleverly you code.

So your data is in 3 million rows by 15 cells, right? Do you know how you want to proceed, then, or are you still looking for ideas?