Insertion of rows without changing formulas on anohter sheets
- by julie
I have two separate spreadsheets which feed each other (one person completes the main one so all others autofill).
I have set up formulas so it autofills but when I insert new lines into the main spreadsheet the other spreadsheet takes information from the wrong line, even though the new data was put in the place of the old data.
(The new inserted lines were put in where the data was before).
can anyone help me to "protect" the formulas from movement?
I will appreciate any help.