Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling selected data from a detail page to a summary
I am trying to pull lines of info from a data page to a summary page. Column
A on the data page contains the classification which is where my condition would be. For example: Phase I 46.56 Smith Phase I 82.43 Jones Phase II 60.00 Ricam Phase I 47.53 Morris Phase II 20.00 Calahan I want to set a driver on the summary page where you could select "Phase I" and it would pull all the lines from the data page that have Phase I in column A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling selected data from a detail page to a summary
Hi!
Take a look at this sample file: http://s58.yousendit.com/d.aspx?id=0...U0FJ1RHCK2YHF3 Biff "Redline" wrote in message ... I am trying to pull lines of info from a data page to a summary page. Column A on the data page contains the classification which is where my condition would be. For example: Phase I 46.56 Smith Phase I 82.43 Jones Phase II 60.00 Ricam Phase I 47.53 Morris Phase II 20.00 Calahan I want to set a driver on the summary page where you could select "Phase I" and it would pull all the lines from the data page that have Phase I in column A |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling selected data from a detail page to a summary
Thanks Biff, just what I am looking for.
"Biff" wrote: Hi! Take a look at this sample file: http://s58.yousendit.com/d.aspx?id=0...U0FJ1RHCK2YHF3 Biff "Redline" wrote in message ... I am trying to pull lines of info from a data page to a summary page. Column A on the data page contains the classification which is where my condition would be. For example: Phase I 46.56 Smith Phase I 82.43 Jones Phase II 60.00 Ricam Phase I 47.53 Morris Phase II 20.00 Calahan I want to set a driver on the summary page where you could select "Phase I" and it would pull all the lines from the data page that have Phase I in column A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create excel spreadsheet on a data access page | Excel Discussion (Misc queries) | |||
working with sub-totaled data without the detail | Excel Worksheet Functions | |||
Sorting Data that feeds into other formulas.... | Excel Discussion (Misc queries) | |||
Varying page Excel report | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |