Display certain Dates on seperate worksheet

[Anthony904]

Hi,

I have a spreadsheet that when a user opens, enters the date range to view data they need. I created an extra column "quarter" to display which quarter the date falls in.

What I wanted to do was,

Create seperate worksheets (Q1,Q2,Q3,Q4), or 1 worksheet with 4 quarters, and Display data according to the quarters.

I will then take the data from the Quarters worksheet and do calculations for the year.

IE..

If the user enters 1/1/05 thru 12/31/05:
There would be data in all 4 Quarters Worksheet.

If the user enters 9/1/05 thru 9/31/05:
There should only be data in Q3 Worksheet.

Thanks for your help!

 

[firefytr]

Sounds like you could either present a couple of input boxes (although they are problematic with users) or a userform with options and/or drop downs (comboboxes) to get the date range. Then you could take this criteria and use autofilter on the desired range (however your data is structured) to only show that data.

To perform calculations on filtered data, check out the SUBTOTAL function.

If you require more help than this, is there any way we could see an example of your data structure? If not, can you describe in as much detail as possible what your data structure is like?

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[Anthony904]

Ok..

I can't post the original xls, but I've recreated with just the data and how I would like to see it.

I want to avoid userforms, just something already in the worksheets that the user can click and view.

http://c.1asphost.com/EthyASC/Quarter.xls

Thanks for the response!

 

[firefytr]

I can't d/l your file for some reason. But any how, if you don't want code, teach them to use AutoFilter.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci