i have this macro but i need to do a midification
this is my macro attachment (workwhile_macro.xls)

CCY_CD is hard code to INR, i want it to inputted manually to any ccy,
INITIATION_DATE which is value date is also hard coded to 1 specific date on the top which i want to input manually.


Account number take value D01000 which is also hard coded i dont want it to be like that (branch code + 000+account)
account_branch is hardcoded to D01 i want to input manually,
LCY_EQUIVALENT is not filling in so i want (AMOUNT*EXCH_RATE)
rest remain the same

Debit and credit are already in the marco.
branch code and Dept code should not be hard coded
Dept code
Branch code
Value Date
remove all the above from the c6, c7, c8 cell and put in the table below in the inputs
put a ccy colum, exchange colum and equivalent column in inputs
here is the output file (output.csv)
the data output file should be taken from the comments in below files
()workwhile_micro_1.xls ) and
(instruction.xls)

Attached Files

excelmacro.zip (205.0 KB, 12 views)