En cours

Update & Revise a Macro File & Profit & Loss Statement

Job Description:

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 accumalate 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)

Compétences : Traitement de Données, Excel, Microsoft Office, Visual Basic, Visual Basic pour les apps

Concernant le client :
( 3 commentaires ) OAKHURST, Australia

Nº du projet : #19843258

Décerné à:

vivirain

Hi there, Greetings! I’m an Excel macro expert and willing to help get the work well done quickly. Best Regards,

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 2 jours
(10 Commentaires)
3.7

17 freelances font une offre moyenne de 80 $ pour ce travail

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(332 Commentaires)
7.9
dgled

I have considerable experience in merging CSV/Excel files and manipulating the data in a structured database for financial/inventory reports. I am a financial expert and a guru in Excel/VBA. I have experience in dashbo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(79 Commentaires)
7.0
bhupendrayadav

I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, financial statement analysis, advanced excel & VBA based models, VBA automation and data processing. I have successfully co Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(25 Commentaires)
4.4
tanveerpd

Hi, Hope you're doing fine. I am well expert and detailed oriented professional by having 14+ years of experience in the same field. I am a fastet typist to run keyboard with 65WPM speed. I love to work for you. Let Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(4 Commentaires)
3.8
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(10 Commentaires)
4.2
razvancotofana

Hello I have a good experience in excel and vba and I'd like to help you. Please feel free to contact me for any additional information. BR, Razvan

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(8 Commentaires)
2.5
habalghost22

Hi , I am an MBA professional have 4yrs of experience in Analytics, advanced excel, vba and other programming languages. I would be happy to help you with your work. I will deliver the project at the earliest based on Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(2 Commentaires)
1.9
diepkha

hi I have a lot of experience in data processing, checking and fixing errors in excel. I can help you fix this error very quickly and accurately. Hope can be cooperated with you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(1 Évaluation)
0.6
halaidesigns

Hi to Australia :) lets CHAT? I have 5 + years experience in this field. Please visit My profile and see the previous project's reviews, I am interested and ready to start, lets discuss with details. looking forwar Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
AnujDangaich2512

Dear Sir/Madam, My name is Anuj and I am a post graduate in commerce and a semi qualified chartered accountant with over 6 years of work experience in handling finance and accounts. I can do journal entries, re Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
jaken05

Hello , I am excel vba developer and excel data model builder.I build pivot table, I build dashboard and data model using excel.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)
0.0
ahmednasser900

hi sir , i can perform this task easily because i have performed many of these tasks early in my life do you can chill out and give it to me

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
AlbertSingh

Hi, I have expertise in excel and excel VBA coding and macros. I'm a professional with over 13 years of experience in back office operations, process designing, quality assurance, analytics in various domains like bank Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0