ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combine 2 ranges in different sheets using Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/123380-combine-2-ranges-different-sheets-using-pivot-table.html)

Jac

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.





All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com