Hi, I am attempting to fill in the macro field (with no success as of yet). Unfortunately it is something that i have very little experience in so i am having to teach it myself as i go. I am inserting an image of a test data sheet. If you could help me with coding the macro for it i would be really grateful. What i need is the code to copy/paste into the new macro field in between the lines; Sub datecatagory() and endsub.
exceldata1.png

Please see attached the image of my sheet. What i need is so when you press the "Enter Data" button at cell F4, the row in the input field -cells B4:E4- would be copied to the apprpriate week based on their date. I have initally just put 3 weeks in , but this will be for the full year.

Thanks

Dan