View Single Post
 
Old 02-28-2016, 06:33 AM
rsrasc rsrasc is offline Windows 10 Office 2013
Competent Performer
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default 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!
Attached Files
File Type: xlsm TB Info-ExcelForum.xlsm (116.2 KB, 10 views)
Reply With Quote