Hi all,



See attachment.

I have the following information in Column B, in cell B5

Account: NF-000-11101

and the same info in cell B10:

Account: NF-000-11101

Therefore, cells B6 thru B9 are empty.



Same thing goes for the following information for cell B11 and cell B25

Account: NF-000-11103

Therefore, cells B12 thru B24 are empty.


Basically, what I need is a macro that will copy or fill the same values between the two same values. See Column C for end results.

If done I would like to see the final results in Column B.

This file has 6,323 rows of info in column A and B.

Thank you in advance for your support and cooperation.

Cheers!

Attached Files

TB Info-ExcelForum.xlsm (116.2 KB, 8 views)