multiple sheets
I have a multiple sheets by country with cluster of data i.e Top 50 A/
for 180days, Top 10 A/R for 150180days etc. What is the best way to consolidate the clusters of data and sort fo entire Asia country into 1 sheet but still by Top 50 A/R 180 days an Top 10 A/R 150180days Than -- Message posted from http://www.ExcelForum.com |
multiple sheets
Hi madcat
I'd consolidate all the data on to one worksheet (possibly by adding an additional column called "Country" on the new worksheet) and then use a pivot table to extract the required data. However its difficult to be more precise without knowing how the data is currently laid out. -- XL2002 Regards William "madcat " wrote in message ... | I have a multiple sheets by country with cluster of data i.e Top 50 A/R | for 180days, Top 10 A/R for 150180days etc. | | What is the best way to consolidate the clusters of data and sort for | entire Asia country into 1 sheet but still by Top 50 A/R 180 days and | Top 10 A/R 150180days | | Thanx | | | --- | Message posted from http://www.ExcelForum.com/ | |
All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com