Generate Sheets into a new workbook and name that workbook

[kons45]

Hi All,

Just learnt about VBA yesterday and by watching Youtube Tutorials managed to copy and amend the code below to do what I want.

Please Login or Register  to view this content.

Basically it Copies Sheet 2 and takes data from Sheet one and generates 1 sheet per day of the month (E.g. 31 for October). I would like to create these 28-31 sheets in a new Workbook and preferably name that file with info from Sheet 1 Cell R42.

This is all very new and exciting to me and that code above may not be optimal but it works and it excites me what VBA and excel can do.

Thanks for the help!