Forum

@riny Thank you, thank you!

@riny Thank you, that will work. Can you tell us how to "see" the power query used so we can duplicate the action? Also, we were hoping to enter one '...

Hi, we have created sample files. One is the 'Inventory Sample' which has been partly filled in (Inventory, Transactions and Products sheets) using th...

@riny Yes, we have all that in an excel spreadsheet that has worked relatively OK with references back and forth between sheets. The relatively simple...

Here's the same file with assemblies and resulting inventory.  

@riny Thanks for replying! We're using Excel for Mac, Version 16.103.2. Here's another example BOM.