I need help to make conditional formatting formula vba

[kishansingh027]

Hi,

I need help to make conditional formatting formula vba code,

PFA excel file Main file and output file

I have one column (brand) and one is (Small image column)

I have data in two cell seprated by | need copy that in saprate rows while condition if brand column have two numbers like 10|8 and (Small image column) there images name then it will be 6 rows like this (Please check Main file and output file for more info)

10 img1.jpg
10 img2.jpg
10 img3.jpg
8 img1.jpg
8 img2.jpg
8 img3.jpg

Please help
Thanks

[FDibbins]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.

https://www.excelforum.com/excel-pro...rmula-vba.html