I would recommend you forget about trying to keep records on two different
sheets and only enter all data on the main sheet. Then you can do Data
Rilter AutoFilter to view any specific date ranges you wish, and if
necessary copy them over to another sheet for Reporting only........not for
data keeping. This will make things easier in the future.

Vaya con Dios,
Chuck, CABGx3





"Chrys" wrote:

I need to automatically copy records containing a specific date range to a
new sheet? I have a file with Names, numbers, dates ranging from 1985 to
2006 and other details and I want to copy the rows that are from 2006 to a
new sheet automatically. Or vise-versa. Enter the data into the 2006 sheet
and it is automatically entered into the "all" sheet. Any suggestions?