RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Experts
I am trying to add an extra column in the Edited Portal sheet within JohnnyL's code. I have edited and made some changes successfully. I want to define the formula in the code and get the result under Narration column N. The formula to be written in the code is shared below. The test workbook link is also shared below
2. Step to add Narration.xlsm
I am trying to add an extra column in the Edited Portal sheet within JohnnyL's code. I have edited and made some changes successfully. I want to define the formula in the code and get the result under Narration column N. The formula to be written in the code is shared below. The test workbook link is also shared below
2. Step to add Narration.xlsm
=$C$1&" "&C2&" "&$D$1&" "&D2&" "&$E$1&" "&E2&" "&$F$1&" "&TEXT(F2,"dd-mm-yyyy")&" "&$L$1&" "&L2&" "&$M$1&TEXT(M2,"dd-mm-yyyy")