Lukket

Update & Revise a Macro File & Profit & Loss Statement -- 2

( 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:

Part A:

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)

Part B:

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)

Evner: Databehandling, Excel, Microsoft Office, Visual Basic, Visual Basic for Apps

Se mere: profit loss statement freelance writer example, provide profit loss statement, profit loss statement word doc, freelance excel work hourly rate, work from home excel projects, home based excel jobs, get paid to make excel spreadsheets, freelance excel spreadsheet design, earn money excel projects, excel spreadsheet jobs from home, excel jobs from home part time, quickbooks 2006 partner draws show profit loss statement, freelance graphic design profit loss statement, profit loss statement startup company, profit loss statement sample, simple profit loss statement freelaner, day profit loss statement, fake profit loss statement, freelance web design profit loss statement, accounting profit loss statement

Om arbejdsgiveren:
( 3 bedømmelser ) OAKHURST, Australia

Projekt ID: #20075100

34 freelancere byder i gennemsnit $57 på dette job

dgled

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 Flere

$250 AUD på 1 dag
(79 bedømmelser)
7.0
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Flere

$50 AUD in 7 dage
(227 bedømmelser)
6.9
ineedWorkJob

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 Flere

$50 AUD på 1 dag
(121 bedømmelser)
6.4
mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on excel macro projects of various complexities and use, based on that i can help you in completing remaining work in your file as per you Flere

$45 AUD in 2 dage
(109 bedømmelser)
5.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Flere

$100 AUD in 3 dage
(104 bedømmelser)
5.8
nelumindralal

Hello, I went thru the description Sorry to hear that your freelancer disappeared. Some people like that attitude Send me the file and I will go thru based on your requirement I just quoted 200 AUD, its an estimated v Flere

$200 AUD in 10 dage
(25 bedømmelser)
4.3
gsanggara

Hi There, I am interested to your project. I am an Excel expert and have a great experiences in Excel automation with formula and vba since my first career 15 years ago. I assured that you will be get high quality / hi Flere

$72 AUD in 3 dage
(24 bedømmelser)
4.0
xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin Flere

$50 AUD in 2 dage
(10 bedømmelser)
4.2
srijanagrawal21

Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of DASHBOARDS, FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Flere

$30 AUD in 3 dage
(24 bedømmelser)
3.8
hemsingh1

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 Flere

$53 AUD på 1 dag
(10 bedømmelser)
3.4
sergeyprince

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 Flere

$100 AUD på 1 dag
(9 bedømmelser)
2.6
sardaaditya28

Hi, I have an experience of more than 4 years, and can assure you to complete the task first as i have done in my previous projects of Excel VBA Macros. Let me know if interested we can discuss this and get star Flere

$35 AUD in 3 dage
(2 bedømmelser)
2.7
diepkha

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.

$25 AUD in 3 dage
(1 bedømmelse)
0.6
ITspecialist247

Hello, Thank you for your job posting. Your job post has caught my attention because I'm a data entry, and web search specialist. I have comprehensive experience in data entry, and web search. I’m a hard working, fast Flere

$20 AUD in 5 dage
(1 bedømmelse)
0.8
pmanalyst

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 Flere

$25 AUD på 1 dag
(1 bedømmelse)
0.7
alekseymihalych

Hallo I'd glad to help. I have enough experience in VBA. Need to llok at your new and previous downloaded templates. Regards,

$211 AUD in 10 dage
(2 bedømmelser)
0.3
redarjm

I have studied accounting. Also, I got great knowledge about excel and data processing.

$35 AUD in 3 dage
(0 bedømmelser)
0.0
navneetmohata

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.

$15 AUD in 7 dage
(0 bedømmelser)
0.0
farooqshah786

Dear Sir, I am writing to you with regards to the Project I am currently working as an Manager Accounts ,IT Admin & Inventory at Al Jannat Malls Rawalpindi and am keen to expand my skill-set and experience. My backgrou Flere

$20 AUD in 7 dage
(0 bedømmelser)
0.0
Excelologist

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 Flere

$55 AUD på 1 dag
(0 bedømmelser)
0.0