Thread: pivot....urgent
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hemant_india[_2_] Hemant_india[_2_] is offline
external usenet poster
 
Posts: 107
Default 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