View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jac Jac is offline
external usenet poster
 
Posts: 58
Default Combine 2 ranges in different sheets using Pivot Table

hi,

i have a file with 2 sheets (Jac'06, Mic'06) of data in the same range A3:F10.
i would like to combine these 2 ranges of data into 1 and paste them in a
new sheet using Pivot Table.

Can i do that? i have been trying it for times but can't get it work!
How actually i have to select those ranges?
anyone out there could please help to advise?

Thanking in advanced.