Sorting data in a workbook.

[Sam]

Hi I wonder if any one can help, I have a work book where I put in comments
from people, in column A ( from cell A5) I have the persons name in B I have
the date and in C I have the comment followed in D the name of the person
entering the comment, the sheet is called Master.
What I would like to do is to be able to create a sheet for each person (
with their name in A1 ) and search and find that Name from column A (Starting
from A5) in the master and copy to the sheet , with all the data in the row
from A to D associated with that name , there could be multiple entries in
that same name.
Is it possible?, Thank you in advance for any help,
Sam.

 

[Dave Peterson]

First, I wouldn't do it.

I'd apply Data|Filter|Autofilter (in xl2003 menus) and use that to show the data
I wanted to see.

But if you really wanted...

I'd still keep all my data in one worksheet and update it there. Then each time
I needed these separate worksheets, I'd run a macro that would regenerate these
sheets. (Keep in mind that those are "report-only" worksheets. Any changes to
them will be lost with the next re-generation.)

If that sounds like an idea you could use, you may want to look at how Ron de
Bruin and Debra Dalgleish approached this kind of thing:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Or:

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