Ok, so I hope i can explain this somewhat,
I need to replicate Production BOM from BC,
However now i need information on a Number from 2 levels above,
If I try to use normal excel to reference the "Number 1" from 2 columns before, it doesnt work because my "Arbejdcenter" is also generated from "Rows", therefore it just moves my references down 1 each time.
Is there a fix for this?
Hope it makes sense
This is a bit hard to explain via a message board post but will do my best. Any time you need to reference a value in a previous replicator, you should use the Cell Reference Workaround technique where you use a column to the left to reference the value you need to "pull down". Those secondary and tertiary replicators should reference those values on the same row, for consistency.
Hopefully this helps illustrate what I mean:
