There's nothing built into excel that does this. You could write a macro that
examines the field and moves the data over to that other sheet. I'd do it after
all the data entry so I could verify my changes before they go to the wrong
sheet.

But if I were you, I'd add a column indicator for the week number. Then I'd use
data|filter|autofilter (or data|sort) to view just the data I wanted. By
keeping the data in one spot, you won't ever have to deal with discrepancies
between your two lists.

===
If you really want a macro, you may find something close at:

Debra's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

or maybe Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

Crimsann wrote:

Is it possible to have the data in a cell on one worksheet automatically copy
itself to another worksheet in the same document?

For example, if I have seperate worksheets for each week in a month listing
income for each day of that week, and the total income for that week tallied
up...can the cell containing the sum for that week be automatically copied to
a seperate worksheet where the weekly totals are being compared to each other?

That way if I change a daily amount, it will not only update the total for
that week on the weekly worksheet...but also update the weekly total on the
monthly worksheet.

It seems like this would be a very useful function, but I haven't found any
information on whether it is possible and how to accomplish it.

Thank you so much for any suggestions...it is driving me nuts! :)

--

Dave Peterson