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

The core difference is the refinement needed to the earlier criteria cols

In your earlier thread where you wanted:
today's data entered for "America"

then this was the criteria given:
=IF(AND(x!$A2="America",x!$BY2=TODAY()),ROWS($1:1) ,"")

Now you want:
data entered for "America"
between a certain startdate to enddate (inclusive, say)

then this would be how the refined criteria should look like:
=IF(AND(x!$A2="America",x!$BY2=D24,x!$BY2<=F24),R OWS($1:1),"")
where D24, F24 houses the specified start/enddates
with your source data in sheet: x,
col A = continents eg: America,
col BY = data entry dates

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"aditya" wrote:
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

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
---

thank you Max

"Max" wrote:

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
---

Welcome, thanks for feeding back
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"aditya" wrote in message
...
thank you Max