Master broken into week 1, week2, etc...

[belly0fdesire]

I have an Access database and I'm going to have the user select a month from a dropdown on a form in the database, have a query create a new table based on that criteria, then a macro will call on a spreadsheet, which will have a database query to the newly created table... the table/master sheet will have a list of order numbers and dates and other data....

what I don't know how to do and need some direction is I need that master sheet to then be broken into 5 other sheets when the workbook is opened... sorting the data into Week 1, Week 2, Week 3, Week 4 and Week 5.

Can someone help me out or point me in the right direction?

Thank you in advance to anyone who replies :D

[sujittalukder]

Cross posted
http://vbaexpress.com/forum/showthread.php?t=13620

[VBA Noob]

Thanks sujittalukder,

belly0fdesire. Please read forum rules below. If you agree to the rules PM me and I will unlock this thread

VBA Noob