Formulas should be filled automatically from specific cell when New data is entered
when data is entered in cell " A9 " even though there is space above e9 should be filled by using the above e1 formula.
Please find the attached file to get a clear picture so that what i need.
I could have dragged the data from e1 till the end but it will take lot of filesize.
Bookmarks