I am importing data into excel from a 3rd party program. each time new information is entered into the program it exports data into Excel and inserts new line at the bottom of the page. I need to calculate data automatically from the cells imported. I have tried to paste a formula in the cells, but as it inserts it moves the formula to the next line down, thus it won't calculate. Is there a way to keep the formula in a column frozen so it will not move when a new row is inserted?
or
I can get the 3rd part program to export a formula into excel with the data. But It will have to have dynamic row numbers. Is there a way to create a formula that will detect what row it is on and thus be able to calculate different cells on the row on which it is inserted?
Bookmarks