Create Excel Macro(s) to Re-organize a Fixed Report
$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.
Nº del proyecto: #11161959
Sobre el proyecto
10 freelancers están ofertando un promedio de $24 por este trabajo
Hi, I am good at Excel and vba. Plz provide me the file to work on. Looking forward to discuss further in the chat.
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
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
I'll design your spread sheet so it automatically generates these reports with a simple to use macro
I have many experience with VBA and I ranked 5th in the Excel worldwide competition organized by Certiport and Microsoft in 2015
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