ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pulling selected data from a detail page to a summary (https://www.excelbanter.com/excel-discussion-misc-queries/65055-pulling-selected-data-detail-page-summary.html)

Redline

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

Biff

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




Redline

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






All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com