Using Excel to create an CSV export - help for a non-profit..

**mjwillyone** · 07-08-2013, 09:34 PM

Friends,

I am looking for some help to take a 4000+ row Excel spreadsheet and turn it into a CSV export tool. Here is the situation.

I would like to have a search box that would allow me to search for the first occurrence of an number in a given column. The account numbers will be sorted in that column from lowest to greatest. When it gets to that number it should take that row and all others that follow having the same account number and simply copy (NOT MOVE) that data to the 2nd tab of the spreadsheet. The user should be taken to the 2nd tab and be provided with a popup box that has three choices: CORRECT NOT CORRECT FINISH. If they click CORRECT they will be moved back to the top of the first tab and be able to enter another account number and the account lines from that search will be appended to tab2, appearing after the other copied info. If they click NOT CORRECT then the row(s) that were just pages to tab 2 will be removed and the user will again be taken to the top of the first tab. If they click FINISH then tab 2 should be exported to a CSV file.

I may be dreaming that this is possible ... if it is possible, then I would love some help.

All this is necessary because we have moved to a new accounting system (the old one was 15 years old and corrupting data) and the new system simply does not have quick way to handle monthly regular contributions by the same donors to the same projects.

I have attached a sample Excel file of the first tab.

This is so important that I would be willing to pay for help on this.

Thank you so much!!
Mike

**hamjam** · 07-09-2013, 04:41 PM

Hello Mike
I looked at this and started a bit of code. It is a bit late for me and I will have another go tomorrow.
The insert file function does not seem to working, otherwise I could leave you with it in the meantime to have a look.

Regards