need a simple program that I can import three excel documents that will sort my accounts easier.
At the moment I am manually doing it.
There will be the main accounts document with all my business sales and calculations in excel
Second document will show all the success fees in % and delivery fees in excel that need to be changed in the master excel doc ( you will find the success fee % and delivery fee based on the order number )
Third document will show the costs of the products in excel which need to link to the order number row and added into a specific cell.
So the program will input each sold product's success fee % based on what the order number is, the delivery cost will be changed the same way as
Keep note some orders could be any amount not just 1, I will have a field that says how many were sold.
The program will put a value of 0 on all the orders that have been cancelled, returned ect.
The program will then compile the data and at the end I will be able to open an excel doc that will show the correct profits.
36 freelancers are bidding on average $141 for this job
Hi, I am well versed with automation in Excel using VBA/macros and can help to automate the accounts in Excel. Please share the files you are having. Keen to work on this. Looking forward to your response. Thanks