Find Jobs
Hire Freelancers

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

$10-30 AUD

Cerrado
Publicado hace más de 7 años

$10-30 AUD

Pagado a la entrega
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 del proyecto: 11161990

Información sobre el proyecto

22 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
22 freelancers are bidding on average $27 AUD for this job
Avatar del usuario
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 en 0 día
5,0 (963 comentarios)
8,1
8,1
Avatar del usuario
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 en 1 día
5,0 (226 comentarios)
7,0
7,0
Avatar del usuario
A proposal has not yet been provided
$30 AUD en 1 día
4,9 (432 comentarios)
7,2
7,2
Avatar del usuario
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 en 1 día
5,0 (96 comentarios)
5,8
5,8
Avatar del usuario
Hi Im an expert in MS technologies I have been working in banking software developmente for the last 20 years regards Carlos
$40 AUD en 1 día
4,9 (31 comentarios)
5,1
5,1
Avatar del usuario
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 en 1 día
4,6 (67 comentarios)
5,4
5,4
Avatar del usuario
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 en 1 día
4,8 (22 comentarios)
4,8
4,8
Avatar del usuario
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 en 3 días
5,0 (54 comentarios)
4,7
4,7
Avatar del usuario
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 en 2 días
4,9 (19 comentarios)
3,2
3,2
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,5
1,5
Avatar del usuario
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 en 1 día
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
Faridabad, India
4,9
445
Miembro desde feb 21, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.