I need an Excel Macro written that will help me populate a database (database example is in the attachment). The source data is provided monthly on a series of excel spreadsheets (11 sheets). The problem I have is that the format of the Excel sheet is like a report, and is not very easily put in to database format (It reads left to right and has a lot of 0’s)
I need a macro that will recreate each new data point (that isn’t a 0) as a row on the EXPOdatabase list, however there are some considerations and these are specified in the attachment.
I believe it would be acceptable to make one sheet in a new workbook that the user copies the cells in to and we run the macro from there (example in attachment)
The macro would reference D1, D2, D3, and then spit out the new rows of data ready for the database. If possible, it would be good to do all of the countries in one sheet, that would make it seem a bit less arduous.
This is not a very hard task for someone who is familiar with excel macros however it will require some VB skills. Only programmers with proven experience should apply as I need this to work first time, every time. It should also be given to me as a user friendly working solution, not a code snippet with no instructions.
