copy data from shet to another based on date

Hi

I have data sorted by date and need to have each months data copied to new corresponding month sheet.

This copy will be triggered by pressing button on original data sheet

Second problem:

The same data to be copied to new sheet. This time half month's data eg. 1.1-15.1

Attached data that needs to be copied

All help appreciated

Br, kontti

Hi,

Try this...

You can change the names of the sheets to what you like. I dont understand your 2nd problem.

Let us know, Mike