Hi Tony
Maintaining two sheets is not a sensible approach.
Why not just have one sheet and sort it either alphabetically or
chronologically depending on which view you want at the time?
Data / Sort will do the sorting for you
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|