Find Jobs
Hire Freelancers

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

$10-30 AUD

Κλειστή
Αναρτήθηκε πάνω από 7 χρόνια πριν

$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.
Ταυτότητα εργασίας: 11161959

Σχετικά με την εργασία

10 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
10 freelancers δίνουν μια μέση προσφορά $24 AUD για αυτή τη δουλειά
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
A proposal has not yet been provided
$20 AUD σε 3 ημέρες
5,0 (22 αξιολογήσεις)
4,1
4,1
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 σε 1 ημέρα
5,0 (2 αξιολογήσεις)
3,4
3,4
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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
Avatar Χρήστη
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

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.