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.
|