First time poster, long time reader ![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Platform: Excel 2010
My report resembles the attached image
The list is about 40 deep. The data, pulled from a program, is pasted into sheet 1 and everything is countifs into the appropriate cell on sheet 2 for the pretty report you see above.
My new ask to add to my report is a new section that would say China top 3 issues: (300) - 23, (400) 17, (3100) - 3 etc. The another for Japan and other countries. Next month, when the new data is pasted, it would update the top 3 issues per country. The allegation types are all unique and there may be a tie for any of the places.
I'm not comfortable enough with VBA.
Any ideas?
Platform: Excel 2010
My report resembles the attached image
![o88lmd.jpg](/board/proxy.php?image=http%3A%2F%2Fi58.tinypic.com%2Fo88lmd.jpg&hash=decb2c60986b196f8bdbe3f58326ef7a)
The list is about 40 deep. The data, pulled from a program, is pasted into sheet 1 and everything is countifs into the appropriate cell on sheet 2 for the pretty report you see above.
My new ask to add to my report is a new section that would say China top 3 issues: (300) - 23, (400) 17, (3100) - 3 etc. The another for Japan and other countries. Next month, when the new data is pasted, it would update the top 3 issues per country. The allegation types are all unique and there may be a tie for any of the places.
I'm not comfortable enough with VBA.
Any ideas?
Last edited: