you can use the following worksheet method:
Workbook_SheetSelectionChange. with it u can check if a
cell within target (a paramater of this function) was
changed and if so copy the changed cell to the desired
sheet.
if you want to check if there was change or not, every
time a range selection is made (whether it is one cell or
more) you should copy the cell to another location (say
another sheet) so that you'll be able to compare it's
value after you leave it.
If i'll find less complicated way i'll let you know.
tal.
-----Original Message-----
I need to have changes on one worksheet to automatically
& identically take place on another one within the same
workbook, including cell formating, sorting, etc...