Copying Same Value Between Two Cells
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!
|