Find Jobs
Hire Freelancers

Create Excel Macro(s) to Re-organize a Fixed Report -- 2

$10-30 AUD

Closed
Posted over 7 years ago

$10-30 AUD

Paid on delivery
Create excel macro that will use data from existing Excel report to: STEP 1: Locate these rows with the following names (see attached), mark them in a column, and filter the report to show only these accounts. These are the only 7 rows in the report we will be working with. STEP 2: Setup formulas and coding for each line in columns called (Debit, Credit, Coding1, Debit, Coding2, Credit). Append data to each row as required by instructions. NOTE1: The formulas on each line are exactly the same. NOTE2: Coding 1 and 2 are specific to the name of the account (e.g. "Total Travel" = 50000.3 and 40002, see report for details) STEP 3 : Arrange the results into a report consisting of two columns. STEP 4: Complete the presentation of the Report. This report belongs in an Excel spreadsheet tab of its own. NOTE: The word :Total" has been removed from the names of the accounts.
Project ID: 11161990

About the project

22 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $27 AUD for this job
User Avatar
Hi, I am good at Excel and vba. Plz provide me excel file to read inline with the document. Looking forward to discuss further in the chat.
$30 AUD in 0 day
5.0 (963 reviews)
8.1
8.1
User Avatar
Greetings! I have been using Excel for the last 17+ years as part of my daily work life. In the process I have done lot of automation similar to your requirement. I can help you with your project. Looking forward to hearing a positive response from you. Have a Great Day! Srinivasan Krishnamoorthi
$20 AUD in 1 day
5.0 (226 reviews)
7.0
7.0
User Avatar
A proposal has not yet been provided
$30 AUD in 1 day
4.9 (432 reviews)
7.2
7.2
User Avatar
Dear Hiring Manager, I have perused your job offer but here is no attachment file. I am interested to perform said assignment. I am Ms Office Specialist. I have professonal level experience about MS Excel and Visual Fox Pro 6.0. Since 2011 to till now I am working as a Data Processor of BBCS Ltd, Dhaka, Bangladesh. I am waiting for your project details. Thanking you. Regards Gonesh Roy
$25 AUD in 1 day
5.0 (96 reviews)
5.8
5.8
User Avatar
Hi Im an expert in MS technologies I have been working in banking software developmente for the last 20 years regards Carlos
$40 AUD in 1 day
4.9 (31 reviews)
5.1
5.1
User Avatar
I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification. Ready to start work immediately.
$30 AUD in 1 day
4.6 (67 reviews)
5.4
5.4
User Avatar
The attachment seems to be missing. I could have a better idea of the explanation if the attachment was present. The explanation does give a fair idea. So the bid holds. If you can just send the file in a pm, then I'll be up to the task.
$25 AUD in 1 day
4.8 (22 reviews)
4.8
4.8
User Avatar
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,Yellowpages,Yelp,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction, and the price is negotiable if required. please award me this project and contact me for further details
$35 AUD in 3 days
5.0 (54 reviews)
4.7
4.7
User Avatar
Hello, I have very good knowledge of ms excel such as formulas ( if, sumifs, vlookup, offsets, countifs, match, exact and average etc. ), charts, pivot tables, Macro and data analysis work. Please contact with me regarding the project. I believe in quality of work. Thanks
$39 AUD in 2 days
4.9 (19 reviews)
3.2
3.2
User Avatar
Hello Sir, I am a new freelance to this site but have experiences in other online freelancer sites. I can assure you to provide 100% quality service within your budget and time line. Below are my qualifications for this Job. * Education - Computer science graduate from Colombo University (Sri Lanka) * 7+ years experiences in computing and data entry * Experienced in Excel, Word, Macro, Developments, WordPress, Joomla, PDF, Etc. * Excel macro development experiences I am looking forward to work with you. Please consider me for this job. Thanks
$25 AUD in 1 day
5.0 (2 reviews)
1.5
1.5
User Avatar
Hi, I am interested in your job as I have a enough good experience in Excel to handle data size 800.000 Row in "Retail Sales Analysis Report" and create a new template of analysis Reports to prepare a professional Reports for top management. I am available to work on your Project. Kindly provide full detail about your project. Best Regards, Mostafa Emam
$25 AUD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Are you looking to hire a virtual assistant? I am a highly-trained working virtual assistant. I am aware that business owners such as you already have a full plate, so I am here at your service to take care of admin and repetitive tasks for you. This way, you can focus more on running and expanding your business. I take pride in delivering consistent high-quality work with a quick turn around. Comprehensive experience in leading business office processes as an administrative assistant, and comprehensive experienced in providing social research for diverse populations within various communities. Committed to service delivery, possessing exceptional communication skills with a keen ability to develop and maintain meaningful relationships with colleagues, clients, key stakeholders and in the community. A tireless work ethic, consistently going above and beyond to deliver quality results and exceptional service to proactively solve complex issues. Tech savvy, having the skillset to adapt to new and changing technologies. Multi-lingual speaking Native Spanish and written and oral English abilities. OFFICE MANAGEMENT AND ADMINISTRATION – Designs, implements, evaluates, and maintains work process within an office in order to maintain and improve efficiency and productivity. RESEARCH AND REPORT DEVELOPMENT – Gathers data from various sources, distills data using spreadsheet, database, and other tools, and creates narratives and graphic presentations to support decision making.
$25 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello how are you? I'm Noelia Delgadillo and I'm an English-Spanish Translator. I've studied English for a lot of years. Also, I'm an Accountant student and I always use Excel. I would like to know more about your project. Thanks
$25 AUD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
I have been working with Macros and VBA for last 4 years I am Confident that i Can give you proper solution for your problem. Yours, Anup Shahi
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
very well can do it in a day time with your high level of satisfaction. i shall use visual basic to complete the project. Kindly let me know for ur willingness
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am having a good hands-on of 4+ yrs in managing spreadsheet data through excel macro tools. I have developemnt a tool similar to your requirement in the past and got appreciation for the same. Likewise I have development a lot of macro tools to automate the tasks. If you find me suitable, offer me a chance to work on your requirement and to deliver the best solution to you
$30 AUD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Faridabad, India
4.9
445
Member since Feb 21, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.