I want to select a cell on one sheet and have it populate a cell on another sheet. From J8 to J804. This what I am using but I have to type it in each cell and it is visible in the cell. is there a way of doing this in macro?

example:
=CVI!J8+VLOOKUP(CVI!J8:J804,CVI!AK14:AL163,2,FALSE)