Thread: Pivot question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
teepee
 
Posts: n/a
Default Pivot question


"Roger Govier" wrote

With your data on Sheet1, in a range from say A1:F100, with A1:F1 holding
the headers, set up a table on Sheet2 with unique values from Sheet1


It says you can only copy filtered data onto the active sheet 8-(