Find Jobs
Hire Freelancers

Excel VBA Report

$10-30 USD

Завершено
Опублікований about 4 years ago

$10-30 USD

Оплачується при отриманні
Looking to find a solution in excel ( VBA) to handle the following: 1. Create weekly, Monthly , year report of one location/ country/ region or consolidation 2. create new service categories and new account to generate the daily/ weekly/ monthly , yearly data 3. update new rates from start of the month or end of the month 4. consolidate all reports into one Process: 1. User will open the excel file ( VBA based) and select the following Region name ( to be added by Admin) location name country name account name to add revenue for the day. on click of submit - a user interface will open where user will be entering and save it. System will then ask user to add new account - if User says - yes then it will ask user to select another account and enter details and it continues until or unless all entries are made. If user - says no and few accounts revenue is not added then system will give error to user to complete the info. once this is done then user will be asked to enter the details such as 1. amount as per system report, POS collection amount, Money order details , Cash collection etc. ( this will be done per account) where as POS collection can be consolidated for all accounts. 2. on submit - system will check - if amount collected matches or not. if not then it will show all details 3. on validation - system crates report format as suggest in one sheet. In master file - another department will be entering deposits in the bank to review if revenue shared by office matches with the bank or not. discrepancies will be validated and shown in a report ( region/ location/ country/ account specific)
ID проекту: 23620626

Про проект

8 пропозицій(-ї)
Дистанційний проект
Активність 4 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language, Data Processing, Excel, Web Scraping, Web Search and Data Entry as well. I’m honest, creative and a unique person to carry out your tasks given to me. Leaving your project on our hand is privileged; we'll make sure that the project is done in a perfect way and do our best until you were satisfied. I would love to discuss this project with you and meet your exact requirements. I am confident I can provide you with top-notch materials that will fit your needs. I'm proud of my work on being professional, of the highest quality and always delivered on time.
$10 USD за 1 день
5,0 (1 відгук)
2,2
2,2
8 фрілансерів(-и) готові виконати цю роботу у середньому за $41 USD
Аватарка користувача
1. I am an expert in Excel,VBA, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 USD за 3 дні(-в)
4,7 (72 відгуки(-ів))
5,7
5,7
Аватарка користувача
Hi, For your weekly and yearly report, with particular location, I think it can be done with a regular formulas, but if need more, I also have some experienced with VBA function. I hope we'll discuss it. I'm waiting. Thanks
$30 USD за 1 день
5,0 (42 відгуки(-ів))
4,5
4,5
Аватарка користувача
Hello sir. I am VBA expert. I am Vb expert and have much experience. Just reading your proposal, i am confident perfect result. I will work for u faithfully. Looking for your reply. Thank u.
$20 USD за 7 дні(-в)
4,9 (7 відгуки(-ів))
3,4
3,4
Аватарка користувача
Welcome to HelpingHut, Here you can find all the solutions related to your tasks. I have huge amount of experience in the field of writing. As a writer, my aim is to generate unique content as per client’s requirements. I can deliver your work within your given deadline and budget. Please give me a chance. I PROMISE you, I will not let you down.
$10 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
i like to do your work kindly consider me as your member for work and provide me work i really happy to work with your team
$20 USD за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
New York, United States
5,0
5
Спосіб оплати верифіковано
На сайті з груд. 21, 2014

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.