S
SMOKN_ENG_MOM
I have a master sheet calculating for certain criteria on another sheet.
As new data is added to the "other sheet" (it is being inserted each time at
row 3)the formula on the master sheet changes to start array at row 4... next
time row 5... etc. So it does not include new data added in the formula.
How can i lock this down to not move with each data entry?
As new data is added to the "other sheet" (it is being inserted each time at
row 3)the formula on the master sheet changes to start array at row 4... next
time row 5... etc. So it does not include new data added in the formula.
How can i lock this down to not move with each data entry?