Copy data automatically onto a separate worksheet
 

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?

Copy data automatically onto a separate worksheet
 

Create a separate sheet for each sales person. On their sheet use =Sheet1!A1
- where Sheet1 is the name of the general sheet and A1 is the cell.
--
Richard


"Ree" wrote:

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?