Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible?
What I would love to do would be to set up a workbook with one master page of
a task list with a column of who the task is assigned to and then have all of the rows where person X is named go to a separate sheet within the workbook that is only for them...possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible?
I'd keep the data in one worksheet.
Then use data|filter|autofilter to see the info that I want. I think you'll find that this is the easiest solution. But if you really, really must. Keep the data in one worksheet and refresh the worksheets whenever you need (not while doing input--just run the macro when you're ready). Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm Code from Debra Dalgleish's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm T R F wrote: What I would love to do would be to set up a workbook with one master page of a task list with a column of who the task is assigned to and then have all of the rows where person X is named go to a separate sheet within the workbook that is only for them...possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|