Export data from master sheet to seperate worksheets dependent on 1-2 conditions

Described below and on the file is what I need to get
I have tried working with other macros from this site to solve this but nothing has stuck yet.


This "Master" worksheet will be filled out daily and will need to populate the other worksheets depending on two conditions. Condition 1: "Date" Cell B7 matches the provided dates in column B of the separate sheets. Condition 2: The drop box will need to match the worksheet name (Sheet1 thru Sheet3). (Chances are that I will have more separate worksheets than the 3 provided but I don't know how many I will need yet), (The "Date" column will be year round as well as opposed to the one month). What I need this workbook to do is export the raw data provided each day in row 7 to the worksheet, provided it meets the two conditions explained earlier. After it is exported the data in the master sheet should be deleted. If this would work easier to just work on the condition where the data is exported by just using the drop box and fill in everything in row 7 as raw data that would work perfectly as well.

Thank you

Try the attached file. I've made one change to your Master sheet. I've added a validation list to D3. If you add more sheets, you will have to add them to the validation list and also to the code. First choose your sheet in D3. Then enter your data starting with the date in B7 and continuing across to H7. I am assuming that all the cells from B7 to H7 will have data. The copying will take place when you enter data in H7 so that should be the last cell that is filled in. Please let me know if this works for you.

Hi Cupomaxwell. I have had another look at your file and have come up with a more efficient code to do what you want. This revised code is shorter and will automatically deal with any additional sheets that you may add so you don't have to modify it as I mentioned in my previous post. The only thing you will need to do if you add more sheets, is to add them to the validation list in D3. Just replace the code in the worksheet module with the following:

Please Login or Register  to view this content.

This works amazingly!
Thank you for the help.

My pleasure.