Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Vlookups
I have a data sheet where 100's of Providers charges, Payments, Adj data are
stored. I have created a pivot table in the same sheet where it will gives a summary of the provider by months. like this.... Provider: XYZ JAN FEB MAR APRIL MAY JUNE CHARGES: 100 200 300 400 500 600 PAYMENTS: 25 40 20 50 100 200 ADJ: 10 15 20 100 75 50 Provider: ABC JAN FEB MAR APRIL MAY JUNE CHARGES: 50 100 150 200 300 600 PAYMENTS: 30 40 60 75 100 250 ADJ: 15 30 40 50 25 40 I am creating a report in the front end where the end user will select a provider. ex Provider ABC... Once the provider is selected it should populate on the summary sheet as Provider: ABC JAN FEB MAR APRIL MAY JUNE CHARGES: 50 100 150 200 300 600 PAYMENTS: 30 40 60 75 100 250 ADJ: 15 30 40 50 25 40 I do not know how to pull all the 3 line for the provider selected. Thanks again for your help. Shaji |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Vlookups
Why not just copy the Pivot table to the summary sheet, drop the Provider
into the Page field and the have them choose the provider from the drop down? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "shaj" wrote in message ... I have a data sheet where 100's of Providers charges, Payments, Adj data are stored. I have created a pivot table in the same sheet where it will gives a summary of the provider by months. like this.... Provider: XYZ JAN FEB MAR APRIL MAY JUNE CHARGES: 100 200 300 400 500 600 PAYMENTS: 25 40 20 50 100 200 ADJ: 10 15 20 100 75 50 Provider: ABC JAN FEB MAR APRIL MAY JUNE CHARGES: 50 100 150 200 300 600 PAYMENTS: 30 40 60 75 100 250 ADJ: 15 30 40 50 25 40 I am creating a report in the front end where the end user will select a provider. ex Provider ABC... Once the provider is selected it should populate on the summary sheet as Provider: ABC JAN FEB MAR APRIL MAY JUNE CHARGES: 50 100 150 200 300 600 PAYMENTS: 30 40 60 75 100 250 ADJ: 15 30 40 50 25 40 I do not know how to pull all the 3 line for the provider selected. Thanks again for your help. Shaji |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Vlookups
I cannot do that because there are many other links to the summary page, so
what I am trying to create is when the end user selects a provider all the these links gets updated related to that provider. Thanks "Ken Wright" wrote: Why not just copy the Pivot table to the summary sheet, drop the Provider into the Page field and the have them choose the provider from the drop down? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "shaj" wrote in message ... I have a data sheet where 100's of Providers charges, Payments, Adj data are stored. I have created a pivot table in the same sheet where it will gives a summary of the provider by months. like this.... Provider: XYZ JAN FEB MAR APRIL MAY JUNE CHARGES: 100 200 300 400 500 600 PAYMENTS: 25 40 20 50 100 200 ADJ: 10 15 20 100 75 50 Provider: ABC JAN FEB MAR APRIL MAY JUNE CHARGES: 50 100 150 200 300 600 PAYMENTS: 30 40 60 75 100 250 ADJ: 15 30 40 50 25 40 I am creating a report in the front end where the end user will select a provider. ex Provider ABC... Once the provider is selected it should populate on the summary sheet as Provider: ABC JAN FEB MAR APRIL MAY JUNE CHARGES: 50 100 150 200 300 600 PAYMENTS: 30 40 60 75 100 250 ADJ: 15 30 40 50 25 40 I do not know how to pull all the 3 line for the provider selected. Thanks again for your help. Shaji |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Vlookups or Match to find multiple information | Excel Worksheet Functions | |||
multiple vlookups | Excel Worksheet Functions | |||
multiple vlookups | Excel Worksheet Functions | |||
Vlookups and multiple returns (again!) | Excel Worksheet Functions |