Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot....urgent
hi
it's tricky to explain my problem but i'll try 1) i am pupolating a sheet with a text file which contains(sheet1) 2) some catagories in numeric form e g 1 for apple 2 for bannana etc 3) i have a these descriptions on another sheet(sheet2) 4) with sheet1 i create a pivottable which contains these catagories in colunms i want to use data on sheet2 as list to correctly display the descriptions of those catagories. how am i to acieve this? -- hemu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot....urgent
On Sheet1, use a vlookup formula to return the text value for each
category, e.g.: =VLOOKUP(A2,LookupTable,2,0) where LookupTable is the table on Sheet2. Include the column of text values in the source range for the pivot table, and add the text field to the pivot table's row area. Hemant_india wrote: hi it's tricky to explain my problem but i'll try 1) i am pupolating a sheet with a text file which contains(sheet1) 2) some catagories in numeric form e g 1 for apple 2 for bannana etc 3) i have a these descriptions on another sheet(sheet2) 4) with sheet1 i create a pivottable which contains these catagories in colunms i want to use data on sheet2 as list to correctly display the descriptions of those catagories. how am i to acieve this? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot....urgent
create an adjacent column that uses the Vlookup worksheet formula.
If you want it to be dynamic as the user manipulates the pivot table dropdowns, then you would have to write code to reapply the formulas although I am not sure there is an event triggered when the pivot table selections are made - so it might be delayed. -- Regards, Tom Ogilvy "Hemant_india" wrote: hi it's tricky to explain my problem but i'll try 1) i am pupolating a sheet with a text file which contains(sheet1) 2) some catagories in numeric form e g 1 for apple 2 for bannana etc 3) i have a these descriptions on another sheet(sheet2) 4) with sheet1 i create a pivottable which contains these catagories in colunms i want to use data on sheet2 as list to correctly display the descriptions of those catagories. how am i to acieve this? -- hemu |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot....urgent
As Debra said, adding the Vlookup column to the source data for the Pivot
Tabel would solve the dynamic change problem without using an event macro. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote: create an adjacent column that uses the Vlookup worksheet formula. If you want it to be dynamic as the user manipulates the pivot table dropdowns, then you would have to write code to reapply the formulas although I am not sure there is an event triggered when the pivot table selections are made - so it might be delayed. -- Regards, Tom Ogilvy "Hemant_india" wrote: hi it's tricky to explain my problem but i'll try 1) i am pupolating a sheet with a text file which contains(sheet1) 2) some catagories in numeric form e g 1 for apple 2 for bannana etc 3) i have a these descriptions on another sheet(sheet2) 4) with sheet1 i create a pivottable which contains these catagories in colunms i want to use data on sheet2 as list to correctly display the descriptions of those catagories. how am i to acieve this? -- hemu |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot....urgent
ok debra, tom
i will try ur suggestions thanks -- hemu "Debra Dalgleish" wrote: On Sheet1, use a vlookup formula to return the text value for each category, e.g.: =VLOOKUP(A2,LookupTable,2,0) where LookupTable is the table on Sheet2. Include the column of text values in the source range for the pivot table, and add the text field to the pivot table's row area. Hemant_india wrote: hi it's tricky to explain my problem but i'll try 1) i am pupolating a sheet with a text file which contains(sheet1) 2) some catagories in numeric form e g 1 for apple 2 for bannana etc 3) i have a these descriptions on another sheet(sheet2) 4) with sheet1 i create a pivottable which contains these catagories in colunms i want to use data on sheet2 as list to correctly display the descriptions of those catagories. how am i to acieve this? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent help on Pivot Tables | Excel Discussion (Misc queries) | |||
URGENT PLEASE! Filtering a Pivot Table further | Excel Worksheet Functions | |||
URGENT! How to read value in pivot table | Excel Programming | |||
pivot table error.Please help! very urgent | Excel Discussion (Misc queries) | |||
urgent-pivot table | Excel Programming |