Hi all,
I am looking to recreate the following formular into VBA
=IF(I2=I1,N1&", "&E2,E2)
But it needs to loop through column "I" until there are no more to loop through. Pulling through the respective data of proceeding data. Essentially a drag fill function.
Can anyone kindly assist?
Many thanks
I am looking to recreate the following formular into VBA
=IF(I2=I1,N1&", "&E2,E2)
But it needs to loop through column "I" until there are no more to loop through. Pulling through the respective data of proceeding data. Essentially a drag fill function.
Can anyone kindly assist?
Many thanks