Hi all, good evening,
need help with Absulute linked fields and druging macro:
when fields are linked to another sheet in the same work book.
the main sheet , the one that we are reading into goes from cell to cell in a column: A1 A2 A3 A4 etc.
the linked sheet, the one that we are reading from goes from cell to cell : A1 A9 A17 A25 ets.
meaning: A1 gets A1
A2 gets A9
A3 gets A17
A4 gets A25.
now I want to add a row and copy the formulas. If I will do it as written in "insert_row" function as "Copy"
then the result will be : A5 gets A26.
the question: how do I continue the chain automatically when a row is added and the formulas ( include absulut linkage) are being copied?
Thanks in advance,
let me know if there is a solution, Please...

need help with Absulute linked fields and druging macro:
when fields are linked to another sheet in the same work book.
the main sheet , the one that we are reading into goes from cell to cell in a column: A1 A2 A3 A4 etc.
the linked sheet, the one that we are reading from goes from cell to cell : A1 A9 A17 A25 ets.
meaning: A1 gets A1
A2 gets A9
A3 gets A17
A4 gets A25.
now I want to add a row and copy the formulas. If I will do it as written in "insert_row" function as "Copy"
then the result will be : A5 gets A26.
the question: how do I continue the chain automatically when a row is added and the formulas ( include absulut linkage) are being copied?
Thanks in advance,
let me know if there is a solution, Please...
