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

Cerrado Publicado hace 7 años Pagado a la entrega
Cerrado 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.

Excel Visual Basic

Nº del proyecto: #11161959

Sobre el proyecto

10 propuestas Proyecto remoto Activo hace 7 años

10 freelancers están ofertando un promedio de $24 por este trabajo

cgullapalli

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 en 0 días
(1180 comentarios)
8.4
satishtl

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 consolid Más

$10 AUD en 1 día
(51 comentarios)
6.1
abhinovpankaj

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 vari Más

$30 AUD en 1 día
(61 comentarios)
5.5
atifarzi

A proposal has not yet been provided

$20 AUD en 3 días
(22 comentarios)
4.1
noeliadelgadillo

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 pro Más

$25 AUD en 1 día
(2 comentarios)
3.4
MarianaVilla

I'll design your spread sheet so it automatically generates these reports with a simple to use macro

$35 AUD en 1 día
(8 comentarios)
3.1
Vloaded

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 Más

$25 AUD en 1 día
(0 comentarios)
0.0
killitmore

I have many experience with VBA and I ranked 5th in the Excel worldwide competition organized by Certiport and Microsoft in 2015

$25 AUD en 1 día
(0 comentarios)
0.0
a2singh5

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 en 3 días
(0 comentarios)
0.0