Create excel macro that will use data from existing Excel report to:
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.
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.
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.
11 pekerja bebas membida secara purata $24 untuk pekerjaan ini
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
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.