Oct 17 2019 02:44 AM
Suffering some apparent limitations of Excel.
Excel cell referencing (i.e. $A$6) can become a major pain when I have to make changes to a complex spreadsheet. Multiple formulas to update etc.
Tracing the formula is a major pain! I.e. Vlookup(A3, ProductMaster!$A$1:$D$25, 3, false) verses Vlookup(Product Code, Quantity In Stock, Product Master).
Who shares the frustration? Any solutions!?
Oct 17 2019 04:34 AM
Oct 17 2019 04:51 AM
Hi @Twifoo,
Finding all instances of where cell referencing has been used in different formulas across different tabs to make updates. Specifically for example in a pricing calculator for a multi-product inventory management.
Oct 17 2019 04:59 AM