my sheet1 is master sheet where data related to all continent is entered. e.g.
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

Here column BY contains data entry date.


I have another sheet (named today data file) which should contain all data
which has been entered in master data sheet today only.I am using today ()
function.Now in master sheet if america is found in column A, I want to copy
entire row data (today's data i.e. row3) to today data file say to A15
across row.
If Europe is found in column A in master sheet,i want to copy entire row to
today data file say to A200 across row.

Today's data sheet sholud not contain yesterday's data or earlier one.
Pls help.

i dont want to use macro.

Thanks in advance