Data needs transferring to the relevant tab

[dpaton05]

I have a spreadsheet that calculates costings. I want a start page or tab that allows you to enter costings for various dates, press a button and for it to filter the entries into the relevant sheet for each month depending on the date of the costing. I already have developed a spreadsheet that correctly produces the costing and this can be copied for other months but how would I create the tab that allows you to enter the info then sort it into the correct month tab?

 

[My Aswer Is This]

I provided a answer to part of your question.
I'm sure others on the forum will be able to help you with the remainder of your needs.

So you are not sure how to do this?

 

[dpaton05]

I provided a answer to part of your question.
I'm sure others on the forum will be able to help you with the remainder of your needs.

Well thankyou for helping me with part of my problem.

 

[dpaton05]

Still unsure how to filter between the different sheets that are named by month and year to enter a costing record based on their date. So a record with a certain date to be moved from the data entry sheet to the relevant sheet according to it's date using vba once the record has been entered and a button pressed.

Could someone help me please?