I have a report with details for a large number of countries. Each month, I need to copy the country details and move them to a sheet specific to that country,
e.g. UK details to a UK folder, Germany details to a DE folder. The level of details available is different for each country. So there may be 10 lines for the UK but only 5 for Germany. However, the country details always start with (e.g.) 'COUNTRY: UK' and end with 'TOTAL FOR: UK.'
Any suggestions on how the macro could look?
I also published the question on:
http://groups.google.com/group/excel-vba?lnk=rgh&hl=en
and:
http://groups.google.com/group/Microsoft-Excel?start=0&hl=en
But so far no one's responded...