Insert new row for breakdown detail data
Good Day Mates,
I'd like to seek your help for my problem.
I have Raw Data in row 2 - 6 and my expectation is to breakdown each raw data by REMARKS INVOICE PAYMENT as can be seen in row 9 - 17.
RAW.JPG
Expected.JPG
If Remarks Invoice Payment contain more than one invoice than it need to be insert as new row, and also including the amount of invoice which contain in between the brackets "( )".
Highly appreciated for the feedback. Thank you!
Cheers!
Click the * Add Reputation below to say thanks.
Maybe something like this ?
The code assumes that the REMARKS INVOICE PAYMENT to breakdown is always in range from cell G3 to G6, the code loop in this range.
Please Login or Register to view this content.
The code also assumes that the value in G3 to G6 will always has the same pattern as seen in the sample workbook, inv#(amount)inv#(amount)inv#(amount)... and so on.
And that if I'm not mistaken to get what you mean.
Last edited by karmapala; 06-17-2020 at 06:47 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks