Excel select on last month and drag/copy the formula present

once new data is pasted in excel sheet(A1:F1). based on last month, the formula should be dragged from other rows and columns(G1:H1) of last month up-to data exist in (A1:F1)
Book1.xlsx (11.9 KB)


Pls help…Thanks in advance

hi @venkateshtangudu

what formula you are using

thanks
Ashwin.S

Hi,

what formula exist in last month should be dragged/copied…
hre formula may be diffenet for each columns…so the formula should be dragged from system last month