Fill in missing data

Hey,
I have a dataset filled from A1 to E35383. A contains dates, but only the first of each month, and it switches months every few thousand rows. There is a certain term in column B, let's say "Pretzels," that appears once in about 4 of these months in non-consecutive months. In other words, I have data for Pretzels for May, January, and December, but not any of the other months. I need to add in a line for Pretzels for the months where it is missing, and just have the corresponding C, D, and E cells say "0" to denote that there isn't data for Pretzels for that month. Here's what I've been thinking for the code so far, but it seems very inefficient and obviously it doesn't work, but it might help you get the idea for what I'm trying to accomplish:

Please Login or Register  to view this content.

If this is the most efficient way to go, then I'd need help getting the missingdates = totaldates - founddates piece to work, I think. If anyone has another solution (which I'm sure exists), please throw it out there. Thanks for the help.

Take care that the last cell of the usedrange in column A has some value (if the last row in column B is 1277, then put a space in cell A1278).

Please Login or Register  to view this content.

snb,
This looks very helpful, but I'm not familiar enough with the code you're using to know what to change for my worksheet (other than changing "string" to "pretzel," presumably). Can you add comments to explain how the code works so that I can go through it and figure out where it's going wrong? Thanks for the help.

I 'avn't got the faintest.. of your sheet, so use F8 in the VBEditor.

columns(1) = column A
columns(2) = column B

Your code runs without an error message, it simply doesn't create any new rows. If you explain how your code is supposed to work, I might be able to figure out what's going on. Sorry I can't post up my worksheet, but an explanation of the code should help out a lot.