Norie and Gday Bruce at the Ozgrid Forum have been very helpful in creating a macro for me that imports country details from a txt file.
There are still a couple of twitches though, I hope I can get some help with. This type of macro is very advanced for me, so I'm starting completely from scratch...
But here goes:
1) I'd like the amounts to be placed in the columns below the headers, rather than in a single string, and don't know how to do that
2) I'd like to include a column called Division and have the division names listed in that column, and don't know how to do that
2) When I import the report in its entirety, I get a "Run-time error '62': Input past end of file" error, and don't know how to correct that
3) I'd like each sheet (except 'All') to sum each column at the end of import, and don't know how to do that
I posted this thread 6 days ago at the Ozgrid Forum but haven't had a response from anyone. I also posted it to Google's Forum yesterday but still no response.
If anyone can help me out I'd be most grateful!
The spreadsheet (ABI Country2) and the text file (fia) can be found under the original link. If you can't get to the data, I can also attach them on this site
http://www.ozgrid.com/forum/showthre...t=47562&page=3