Hey,
I'm trying a different tack on my overarching problem. I'm using the following code to move data from sheet 1 to sheet 2:
Please Login or Register  to view this content.
The problem is with the "And" phrase. It checks above the target cells on sheet2 to see if the dates there (Row 1 of sheet2) match up with the date of the to-be-transposed data from sheet1 (Column A of sheet2 at a given "rowcount"). If the date matches up, it goes ahead and throws the data in the appropriate place.
This works until there is no data for "Marble" for one month, because that throws the check against the date off by 1. So, on all the next checks, the date will not match up.
Is there a way to put a zero in the target cell on Sheet2 if the date doesn't match up, and continue to do so until the date does match up (at which point it should throw the data into the target cell), and then continue on.
So if I had data for Jan. and March but not February, I would like the code to recognize this, put a zero in the target cell for Feb, and put the appropriate data in Jan. and March.
I realize that might be confusing, I'd be happy to explain more, I just can't post the workbook. Let me know if you have any further questions, thanks.