Ditutup

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

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.

Kemahiran: Excel, Visual Basic

Lihat lagi: mark travel, excel macro to word, excel macro create worksheet, excel macro create number xml files, excel macro create internet explorer, excel macro create dat file, excel macro create file, excel macro create folder, excel macro create file local directory, excel macro create files, excel macro create xsd, excel macro create unique file worksheet worksheet name, excel macro create shape, excel macro create txt file, excel macro create text file, excel macro create permutations, excel macro create directory mkdir

Tentang Majikan:
( 298 ulasan ) Faridabad, India

ID Projek: #11161959

11 pekerja bebas membida secara purata $24 untuk pekerjaan ini

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 dalam 0 hari
(864 Ulasan)
8.0
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 Lagi

$10 AUD dalam sehari
(50 Ulasan)
6.0
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 Lagi

$30 AUD dalam sehari
(58 Ulasan)
5.4
atifarzi

A proposal has not yet been provided

$20 AUD dalam 3 hari
(22 Ulasan)
4.0
MarianaVilla

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

$35 AUD dalam sehari
(8 Ulasan)
3.0
$15 AUD dalam 0 hari
(0 Ulasan)
0.0
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 Lagi

$25 AUD dalam sehari
(0 Ulasan)
0.0
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 Lagi

$25 AUD dalam sehari
(1 Ulasan)
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 dalam sehari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0
inspirovation

I can create one button click Macro to read the contents from specific fields, calculate and generate a new sheet with organized report based on the input data.

$20 AUD dalam sehari
(0 Ulasan)
0.0