![]() |
Show values from other sheet
I have a Pivote table on sheet1 as follow:
Column A ColumnB Product Type a 1 3 4 b 6 9 f 10 15 The column A show a lot of products with diferent types on column b, the types can be only 10 different types On sheet2 I need show all values displayed in sheet1 for the Product that I select on sheet2 I have 10 spaces between each product For example: If I select on Sheet2 product "b" and "f" need show the follow: In write in A1 "b" need show: ColumnA ColumnB b 6 9 the 8 spaces after I write in A11 "b" need show: f 10 15 I will appreciate your help a lot have 7 months traying to found how can do that Regards |
All times are GMT +1. The time now is 03:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com