Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically copy select rows to different page?
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 --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically copy select rows to different page?
scottjk,
Try DataFilter=Advanced filter for some examples visit this page by Debra Dalgleish http://www.contextures.com/xladvfilter01.html Cecil "scottjk" wrote in message ... 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 --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select data in non adjacent rows of a column automatically | Excel Discussion (Misc queries) | |||
Copy rows from one worksheet automatically, ignore rows that are b | Excel Worksheet Functions | |||
Automatically select empty rows | Excel Worksheet Functions | |||
Select alternate rows to copy | Excel Discussion (Misc queries) | |||
Automatically select range and copy to new sheet | Excel Programming |