Transfering data from one main sheet to multiple worksheets via date and status

Hello, very new to all this so might be getting a little too creative but I have a worksheet which has a summary for sales and then I have created other worksheets via month which automatically update the summary. What I would like to do is add another sheet as a Sales list where you can see every sale and what status it is on. We would like to use the sales sheet as the main data entry which will complete the monthly worksheets as well using the filter of date and status if possible. I know you may say to just have the one list but then it still won't update the summary as we require unless anyone has an idea to possibly make that work.

Any help will be greatly appreciated as I cannot seem to find what I am looking for, or as I said I might be getting too creative and just need to come back to reality.

Hello

Thank you for responding to me, I'm only able to save as a PDF but the first page is the Sales List and then the summary on page 2. The other pages are done by month i.e. Jun 17, Jul 17, Aug 17 etc.

So sorry as attached

Hiya

So basically what I would like to do is have the Sales List as the main page for entering new information. This will then be linked by the month and status filled in columns A and M. So if I enter new information for June within Sales List, this will then upload in the correct tab name Jun 17 and go into Won, In progress or Lost when the user selects the status in column M

Yea I have kept it small as we don't have a lot going through each month, but it may increase at some point in the future

That's lovely thank you, If we select In progress though it goes to Lost and Lost items go to In Progress.

The data can stay on the Sales list as its just an overall worksheet but if we changed a status on the sales list it will go to the relevant status is there any way of deleting it from where it was originally. For example if I have a status as in progress and we win it when I change it on the sales list it goes to won and deletes from in progress if possible.

Originally Posted by SBlack6

Yea I have kept it small as we don't have a lot going through each month, but it may increase at some point in the future

This should adjust if the row exceeds 11.
The code will run each time you deselect "Sales List" sheet, or you could run "test" from the macro list Alt + F8.

Please Login or Register  to view this content.

Thank you jindon that works perfectly exactly what I envisioned

Thank you sintek for all of your help. You really did get where I was going with it. Sorry to be a pain, but you did do very well and were so quick to respond to me and patient.

Thank you again