( I posted this project few weeks back. a free lancer almost completed the first task 80% but then they disappeared and cannot get a response from them despite repeated reminders) , you will start from where they stopped and the last update they provided.
------------- original project details below--------------------- Note some part of first task are already completed - Read below sending your proposal----------
I have a MS excel Macro file, that is designed to use download from the selling and payment platform and calculate the profit for each item sold as well as accumulate the total sales and profit.
Due to some changes in the template of download file (source files ) from the selling plat from : the macros are not working as required. Hence I need someone with Advanced Excel and VBA skills to:
1: fix the current file to match the changes ( with the source file) – 90% Complete
2. update formulas to match the Ebay Fee & Paypal fee rate changes ( My sales Record Tab & Inventory Tab)
3. add additional columns to match the changes ( Refund , promotions cost & Courier labels) ( My Sales Record Tab)
4. create new macros to add shipment cost from a new download files ( based on Courier Labels & dates) ( My sales Record tab & Dashboard)
5. update formulas in inventory sheet
6. Add Vendor performance ( New Sheet)
7. Ensure all formulas and macros are working perfectly ( e.g. when multiple items are sold in one transaction, macros can create separate record a single transaction to capture individual item cost, sale price , divided postage and
8 Dashboard is updated accurately
Create a new summary report of
1. Overall financial statement : profit and loss & balance sheet ( i will provide the template as well as logic)
2. repeat buyers sheets
My current Macro file has no password and i want you to keep it like that.
Payment will be made in two part
1. 65% for completing Task 1 (100% satisfied and working)
2. 35% for completing Task 2(100% satisfied and working)
No milestone will be set.
12 фрилансеров(-а) в среднем готовы выполнить эту работу за $58
Hi, I have understand the project requirement & interested to update macro for this project. Please send a message so we can discuss more & start the project. Thanks.
Hi, I have understand the project requirement & interested to update macron for this project. Please send a message so we can discuss more & start the project. Thanks.
Am proficient with Excel VBA and macros and am good at understanding pre-written code and building on it. Relevant Skills and Experience MS Excel VBA, Macros, Programming skills