( 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----------
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) - ( My Sales Record Tab & Ebay sales record Tab) ( New template in the Tab " NEW Ebay Sales Record Template)
2. update formulas to match the 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)
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)
Bu iş için 34 freelancer ortalamada $57 teklif veriyor
Hi, I a financial and market analysts and guru in Excel/VBA/Macro, who prepare business plans, feasibility studies, market research, financial models and other in a simplified and logical manner including explicit anal Daha Fazla
Greetings sir, I have read your project details and i will update your macro file and start from where your previous worker left of. Sir, i can deliver this project sooner than you expect and will be over your sa Daha Fazla
Data Processing, Excel, Microsoft Office, Visual Basic, Visual Basic for Apps skilled professional with the required expertise. Can help to deliver the solution as needed on the expected lines. Please private message m Daha Fazla
Hello. I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work o Daha Fazla
hi I am an expert in VBA Excel, I have 6 years of experience and a lot of skills in processing data in Excel using VBA. You will get the correct and fast data. I can make your request quickly.
Hello Dear !!! I am able to continue your project as you described. I am currently working as Data analyst, MIS reporter and VBA programmer in a MNC company. I am able to understand VBA coding that already done in yo Daha Fazla
I am self motivated, trustworthy and focused. I am [login to view URL] Graduate. I have great skills in excel with giving desired output in timebound manner with utmost accuracy.
I am an experienced professional in Automation on MS Excel, Power Point and MS Word. I create fully dynamic Excel Spreadsheets and Power point presentations, which can fetch data from Word, PDF, Another Excel File, Pow Daha Fazla