Quote Originally Posted by aselcuks View Post
MMVAL V1_BOM.xls

That is the sheet I wanna modify and after the code executed I want it to be like;



MMVAL V1_BOM_modified.xls


but It fullfills the rest of column K with the last statement "C15" and it goes down to length of longest column.


Thank you for your concern.

Regards



Also if there is any blank cell lets say G20, after execution it fulfills the shifted cell of G20 with the value of G19, it doesnt leave it blank as it was before.