Dear All,

I am new to the Excel macros and VBA tools and however i have some design idea how My Tool needs to implemented, We need your support and assistance to get this created, please help here.

Need a help to create macro code by using VBA command Tool.

I have 3 sheets here.

A. Summary Tab (Here I would be uploading a input sheet )
B. Output Tab = required columns to be upload into a server
C. Input Tab = uploaded sheet info will be populated here

Problem Statement:

Input Tab:-> Data alignment command button ( after clicking, it should work as per below)

a) In column “D “ blanks Rows need to be removed
b) Towards to last, I mean in “ BN” column heading name to be added as “Total”
è Column header replacement
1. Business Agreement ID – replaced with Account Number
2. BP ID – replaced with Invoice Number
3. NMI/MIRN/DPI –replaced with NMI
4. Bill Start Date -Period From
5. Bill End Date -Period To
6. Peak Consumption– Peak
7. Shoulder Consumption –Shoulder
8. Off Peak Consumption-OffPeak
9. Capacity Value-Capacity
10. Service Charge-Service
11. Discount Amount($)-Discount
12. Usage and Service Charges-TotalIncGst
13. Total Amount Due -TotalDue
14. In Columns “O & P “ columns we have dates in the format of “YYYYMMDD ‘ and this columns should be replaced with DD/MM/YYYY format
15. Column Name heading –“ BO” name to be updated as “Temp ID” and it should do concatenate " D+A+O" columns

Output Tab: heading names i have already pasted here and now we have 2 command buttons.

-> Command button 1 - Data fetch & Refresh (After clicking, it should fetch the data from the Input data in the below format

a) Each row line item from input data sheet - > should create a 9 rows (times)
b) It should fetches the data based on
c) Based on the heading names in the Output sheet - >fetches the corresponding data from the sheet on below heading

Data should be populated based on heading Index and matching in all 9 columns except( I mean we are repeating row items)

Please help on this

Attached is the output file which has been updated manually , please please on this

Thanks & Regard,
Hari Prasasd B

Attached Files

Summary file for Bid creation-Output.xlsm (22.5 KB, 12 views)