Excel VBA programmer to design a VERY simple order tracking dispatch system. I already have a spreadsheet system with some macros but it is a little complicated and time consuming to use. A VBA system will work much better.
Here’s my process which needs a system:
[url removed, login to view] downloading a CSV file of orders, I separate name fields using macro. Sometimes there are too many names in name fields which cause the macro to stop. I think adding a middlename field will solve this.
[url removed, login to view] this file into a master list of orders
[url removed, login to view] off payments and check payments
[url removed, login to view] 2 dispatch lists from paid but not shipped orders. One dispatch list is formatted one way and needs to be emailed in CSV format to the shipping company. The other dispatch list is formatted another way and printed. The latter is for orders that are packed onsite.
[url removed, login to view] orders have been dispatched, mark them off as dispatched.
[url removed, login to view] orders to check which are paid and which aren’t.
I need to streamline the process and use VBA/Macros to make this task easier and simple.
I’ll show the winner step by step what I currently do so you can understand the process and create the spreadsheet from there.
Timeframe: 1 day
25 freelancers are bidding on average $81 for this job
Hello, I have worked on many Excel VBA projects and would be glad to take up your project as well. Hoping to hear a positive reply from your part. Kind regards.
Well, this kind of project should be done in MS Access. There will be a lot more flexible and can provide more function. You might not even to write a single line of code to do what you want to achieve.