You'll probably need to do this with VBA. First you'll need to decide what
you want to do.

* Do you want to "autofill" the next two sheets COMPLETELY with information
you enter into the first sheet?
* Do you want to "autofill" the next two sheets with a particular row or
column of data when it's updated.
* If you change the value, do you want to copy that over as well?
--
HTH,
Barb Reinhardt



"GetSFX" wrote:

sheet1 witch is what i fill out (source data)i want the data to be auto filld
into the next too sheets..an to also sort the the data (by date- verry
important) from the 1st sheet. all 3 sheets r totaly difernt..same names
though..

thx for any help