Automatically copy select rows to different page?

  • Thread starter Thread starter scottjk
  • Start date Start date
S

scottjk

I'm working on a sheet that will list events in chronological order by
date. Each date will contain 1 of 4 partners names. What I would like
to be able to do is automatically copy each partners
information on a different page to allow me to print a seperate page
containing that partners totals. The end result will be 5 pages. 1 main
page with ALL events then pages 2-5 with the totals of each individual
partner.

Ex. Page 1

Date Dep Arr Time Fuel Partner
12/5/2003 SLC LAX 2:50 145 Scott
12/6/2003 SLC SAN 2:55 150 Tom
12/7/2003 SLC SFO 3:10 210 Jack
12/7/2003 SLC GEG 2:00 125 Scott

Ex. Page 2

Date Dep Arr Time Fuel Partner
12/5/2003 SLC LAX 2:50 145 Scott
12/7/2003 SLC GEG 2:00 125 Scott

And so on for the other partner.

Thanks

Scott
 
Back
Top