in one sheet i need to show particular selected month details and in another sheet i need to show up to that month details. That means in one sheet i select "march"it will show march details.in another sheet its need to show " jan,feb,mar" details.
The most expedient way to accomplish this is to create a dashboard with three worksheets, one for the current month, one for the previous month, and one for two months prior. You can then use a filter action driven by the current month to appropriately filter the other two worksheets. It is a bit of a kludge but it gets the job done.