Find Jobs
Hire Freelancers

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

$10-30 AUD

Закрито
Опублікований over 7 years ago

$10-30 AUD

Оплачується при отриманні
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.
ID проекту: 11161959

Про проект

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

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

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

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
10 фрілансерів(-и) готові виконати цю роботу у середньому за $24 AUD
Аватарка користувача
Hi, I am good at Excel and vba. Plz provide me the file to work on. Looking forward to discuss further in the chat.
$30 AUD за 0 день
5,0 (1180 відгуки(-ів))
8,4
8,4
Аватарка користувача
Have done simiilar name or string searching in excel and transferring data. • I have good skills in Excel automation and used extensively the macros/VBA to automate: • Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. • With summary data plotting graphs, bringing pivot tables etc. • Outlook autoamtion - Peforming different actions other that using the existing rules, updating calendars based on logic. • MS Access - Expert in designing table, user input forms and also reporting from data. • Excel to MS access data porting and conversion and designing new system for use. • Please review my portfolio on recent projects completed.
$10 AUD за 1 день
4,7 (51 відгуки(-ів))
6,1
6,1
Аватарка користувача
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$30 AUD за 1 день
4,9 (61 відгуки(-ів))
5,5
5,5
Аватарка користувача
A proposal has not yet been provided
$20 AUD за 3 дні(-в)
5,0 (22 відгуки(-ів))
4,1
4,1
Аватарка користувача
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 за 1 день
5,0 (2 відгуки(-ів))
3,4
3,4
Аватарка користувача
I'll design your spread sheet so it automatically generates these reports with a simple to use macro
$35 AUD за 1 день
5,0 (8 відгуки(-ів))
3,1
3,1
Аватарка користувача
Hello! This is actually my first time using this website but I am eager to get started and this looks like a perfect project. I have a full time job at an investment company in Boston, but am looking to make some money on the side. I specialize in data management, organization and have proficient Excel that include building macros to help make our procedures more efficient. Because my job allows me to exclusively deal with Excel, I feel as if have the knowledge to make sure no matter what information is being put into this sheet, that the macro will do it's job to organize it the way it should be. This would be my first free lance work but you won't regret it! If you have any questions please reach out to me and I'll be happy to respond! Take care,
$25 AUD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I have many experience with VBA and I ranked 5th in the Excel worldwide competition organized by Certiport and Microsoft in 2015
$25 AUD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I will automate this such that you can click a button and the report will be generated and filed in the folder you specify with the name you specify. Regards Ajit
$25 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор INDIA
Faridabad, India
4,9
655
На сайті з лют. 21, 2015

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

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