Copy cells

[arnab0711]

Hi,
I have this workbook,where I want to copy-paste the last visible cells into blank cells in column c & D
Please advice if there is any short cut in doing the same.

[canapone]

Hi,

not sure to have understood: in A4

=A3

Copy A4 (control+c), select area B4:D1769, press F5, select Special, select empty calls. Select Ok, enter.

Select all the area again B4:B1769 , copy and paste specials values.

Regards