customised sheet from master sheet

[aditya]

I need customised sheet from master sheet.I have different sheets like this.

sheet1 - Content page where other sheets hyperlinked
sheet2-Master data sheet where data entry is done
Sheet3-America specific
Sheet4-Europe specific

data entry in master data sheet is done as follows.

A B C D ....... BY
1 America US Big 1 8-Jun 09
2 Europe Britain Big 3 9-Jun 09
3 America Canadan Medium 7 9-Jun 09

Column BY contain data entry date.

In content sheet ,there are 2 cells are like this

D24=From this date
F24=To this date
These two dates will be filled manually as desired.

i want my sheet3 to copy all cell data (across row) if column A in master
sheet contains America.These data must fulfill date condition entered in
content sheet.
i.e. sheet3 is america specific sheet from perticular date to perticular
date as entered in content sheet manually.

Similarly i want sheet4 europe specific from perticular date to perticular
date (as entered in content sheet).

This should update automatically whenever i enter date in content sheet.
i dont want to use macro.

Thanks in advance

 

[Max]

For copying down purposes, D24 and F24 needs to be fixed (with $ signs) in
the indicative criteria expression:
=IF(AND(x!$A2="America",x!$BY2>=D$24,x!$BY2<=F$24),ROWS($1:1),"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---

 

[aditya]

thank you Max

 

[Max]

Welcome, thanks for feeding back
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik