VBA Code Button that runs through Date list Table and Copies onto another table

Hi All,

I am a VBA novice and thus is why I am on here looking for help.

My issue is that I am looking for a piece of code that can be activated by a button and it runs through the data list sheet and identifies which sections fulfill the criteria for each months table. The most difficult part that I am looking for help with is how the code can identify if there is more cell rows required that it adds onto the end of the existing table and if there is less required(empty rows) then it removes these. I have included an example to refer to.

Any help would be hugely appreciated and thanks in advance :)

like :

Please Login or Register  to view this content.

Thanks for the response ranman,

However this doesn't solve my issue of identifying what date to stop at and move onto the next month data whilst controlling the overall formatting of the sheet.