Copy data automatically onto a separate worksheet

Giganews Newsgroups
Subject: Copy data automatically onto a separate worksheet
Posted by:  Ree
Date: Thu, 11 May 2006

I have a general worksheet with all my sales team listed with their daily
sales.  I want to have separate worksheets per team member that once their
details are on the main listing it picks up their name and automatically puts
their details onto another worksheet so they can view their own sales,
instead of me having to filter it every day.  Can this be done?

Replies