Hi, sorry in advance if this has been asked for. What I’m trying to do is reference a cell and lock it into a formula similar to how in excel you would do the following for example;
=A1*'TAB2!$A$2
Thanks,
Thanks for replying back Justin. Here’s what I am trying to achieve.
Tab 1 - I have a list of products with unit cost for each specific country ( rows). There are multiple countries listed (Columns) in this tab.
Tab 2 - Each country is assigned a va...