Hi all,
please help me for the below,
In a spreadsheets There is a formula in cell "D1" and "E2".
i have a data in the same sheet from 3rd row, every time i add data and copy formula from "D1" and paste for new data which is added last and i will double click autofill so this formula reflect to all data.
simiarly i copy Formula from E2 and i past this formula in E column only to the newly added data.
And since now i have pasted the formula and autofilled so to reflect to all newly added data. i do copy paste special so to retain values
Anyone could help me to obtain this via vba code.
i have attached example spreadsheets.
Bookmarks