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
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)
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