| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up Data from Worksheet within same Workbook | New Users to Excel | |||
| Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
| Pasting data without the worksheet automatically delimiting it? | Excel Discussion (Misc queries) | |||
| automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
Hybrid Mode
