Excel 2010: Automatic Date Filing

hi,

its simple. go to file menu of excel, go to options, click cutomize ribbon, in right panel check developer, that would add an xtra developer tab in excel
then go to developer tab, click insert in developer tab and wld show different buttons, select a button and create anywher ein excel sheet by sizing the button, as u create a button a new window will come up asking about macro, give a name to macro and click new
that will give you window to enter macro, once u enter the code that I gave, just manipulate some terms based on my explanation in previous post for your columns and rows.
so after you enter the code (which should b in a format mentioned above) you just have to press the button that u made to get your formula working

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