We need someone that has the skills to create a Excel Spreadsheet with Macros.
The ideal situation is that when we open the spreadsheet, we click a button to import .CSV file and it will direct the user to select the .CSV file and the it will import that data and arrange it in the way I will provide.
The spreadsheet is called "End of Month Closing Report" and this report will be used for internal business use as we are a serviced office provider:
1. How much we will ne invoicing clients from last month vs this month
2. Top clients by location (who has spent the most this month)
3. A summary of the spend (rent / internet / telephone / services)
Ideal person is a Visual Basic expert with great communications skills.
I have attached a sample of how we envision the final report once data is imported and manipulated.
Hi there. Just checked your doc and project desc. I can be of help on this (csv import with a confirmation box) So that, this csv will be the raw data for your analysis file. Let me know if you are interested. Thanks..