populate cells with the same value as the cell above (same column)

Hi,

I have a huge file with data and I want to populate same cells with the value as the cell value above of it in column B, C, D if I have value in column G.
I add a test file with before/after!

Thank you very much for your help.

Assumes your data begins in Row 1

Please Login or Register  to view this content.

Hi,
Thank you for your solution. I think we are on the right track.
...it cleared all 3 columns, B, C, D

sorry..
this is the original piece of data, it starts in row7
01-Apr-17 187 73G BGF 93
01-Apr-17 302 73G BGG 91
01-Apr-17 364 73G BGF 81
01-Apr-17 422 73G BGF 89
01-Apr-17 647 AT5 ATG 32
02-Apr-17 151 318 ASD 81
02-Apr-17 152 318 ASD 81
02-Apr-17 207 AT5 ATD 91
02-Apr-17 273 AT5 ATG 99
02-Apr-17 305 73G BGH 41
02-Apr-17 321 73G BGF 81
02-Apr-17 373 733 BGA 93
373 733 BGA 81 -this is added by me
02-Apr-17 374 733 BGA 93
02-Apr-17 382 733 BGA 89


after I run the code it gives me:
01-Apr-17 187 73G BGF.........
01-Apr-17 187 73G BGF
01-Apr-17 187 73G BGF
01-Apr-17 187 73G BGF
01-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF

it should copy when it finds an empty cell...

Try changing this line of code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thank you! that's it!

John55,

Since you have a 'huge" file it might be worth considering using special cells as it seems to be faster. (although you might as well test on your data)
http://www.contextures.com/xlDataEntry02.html

Thank you scottiex!