Creating summary from a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UKMAN - 21 Sep 2007 08:26 GMT

Hi,
I have a sheet with 8 columns that records the courses that people in the
company go on. The heading are: Rec ID, Name, Dept, Team, Course, Cost,
Status, budget.
Each row is unqiue and probably reach 100. (I understand to use match that I
will have to extend my columns to this amount but thats not a problem)

I need to produce a report that will allow me to select a dept and all the
rows that have that show that dept are copied to another area under a
prepared title.

I know you can use advance filter but that means copying and pasting but
this has to be automated so anyone can do it.

This is a panic job.... so many thanks.
Colin

Reply to this Message

Roger Govier - 21 Sep 2007 09:54 GMT

Hi

There is no need to copy and paste. Advanced Filter can extract data to
another sheet, and can be combined with a macro to automate the procedure.

Take a look at Debra Dalgleish's site. She has lots of help on using
advanced Filter
http://www.contextures.com/xladvfilter01.html#ExtractWs

Lots of example downloads here
http://www.contextures.com/excelfiles.html#Filter

This downloadable file may help you to resolve your requirement.

http://www.contextures.com/AdvFilterCity.zip

Signature

Regards
Roger Govier

> Hi,
> I have a sheet with 8 columns that records the courses that people in the
[quoted text clipped - 14 lines]
> This is a panic job.... so many thanks.
> Colin

Reply to this Message

UKMAN - 26 Sep 2007 10:56 GMT

Roger,

Many thanks for the pointers and I'll reseach through there.
Great job you guys do.
Cheers
Colin

> Hi
>
[quoted text clipped - 30 lines]
> > This is a panic job.... so many thanks.
> > Colin

Reply to this Message