Find Jobs
Hire Freelancers

Excel VBA Report

$10-30 USD

완료함
게시됨 약 4년 전

$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년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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
결제 수단 확인
12월 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)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.