Jaime,

The normal way is to have one table, and sort it as needed when needed.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jaime S." <Jaime wrote in message
...
I have two similar worksheets within the same workbook. One sheet is
sorted
by name and the other sheet is sorted by a date for a speicfic name. Is
there a way to change the date on the sheet, sorted by name, and that will
automatically find the name on the other sheet(sorted by date) and change
the
date to the second sheet?