![]() |
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