Completed

Excel VBA Report

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)

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing, Software Architecture

See more: generate report word using excel vba, access convert report excel vba, money excel vba, generate report excel vba macro, excel vba staff leave report date leave type, excel vba build format report, singapore looking excel vba programmers, excel vba import info project, excel vba create expense report, excel vba want view external crystal report, excel vba tutorial generate report, convert report excel vba, money programming excel vba, read csv excel table report vba, excel vba financial report, project excel vba report, excel vba report example, excel vba report, excel vba report automation, excel vba report generator

About the Employer:
( 4 reviews ) New York, United States

Project ID: #23620626

Awarded to:

omoboladeolumode

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 More

$10 USD in 1 day
(0 Reviews)
0.0

9 freelancers are bidding on average $40 for this job

citijayamala

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 projec More

$150 USD in 3 days
(72 Reviews)
5.7
nurnga1218

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. T More

$30 USD in 1 day
(41 Reviews)
4.5
ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o More

$75 USD in 3 days
(17 Reviews)
4.5
AStream1210

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 in 7 days
(7 Reviews)
3.4
mochih321

[login to view URL] are you? I have just read your description carefully. As an experienced developer, I am sure that I can handle your project perfectly. Let me know If you have any time to discuss for more details with me. Loo More

$30 USD in 2 days
(3 Reviews)
2.4
galuharump

Hi i am galuh arum from Indonesia. I am a new freelancer but in the full time worker i have experience as technical sales in multi national company Atlas Copco Indonesia for almost 4 years. I have good experience in ha More

$15 USD in 20 days
(0 Reviews)
0.0
HelpingHut

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 requirement More

$10 USD in 1 day
(0 Reviews)
0.0
rajeshshrimali

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 in 7 days
(0 Reviews)
0.0