LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 106
Default Create a worksheet based on filtering of another?

I have a worksheet with a list of tasks and 20 columns of details related to
each task.

One Column lists the person the task was assigned to.

I am trying to create a worksheet for each person that is assigned tasks
(thus, the tasks that show up when filtered for their name). I would expect
that worksheet to update automatically when the task list is updated. It also
doesn't not need the full 20 columns from the original task list.

Is this possible?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto create a schedule based on a worksheet. fyrefox Excel Discussion (Misc queries) 0 September 14th 07 12:24 PM
How can I create a fill that increments based on worksheet numbers Amanda097 Excel Worksheet Functions 3 February 7th 06 08:39 PM
Create a master worksheet based on 2 different worksheets Kristina Excel Worksheet Functions 0 August 23rd 05 06:41 PM
How to create a fill down that increments based on the worksheet n Skot Excel Worksheet Functions 7 August 2nd 05 04:47 PM
Filtering data from one worksheet based on another SKKB Excel Discussion (Misc queries) 2 April 15th 05 06:52 PM


All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"