Forum Discussion
jstarbird
May 23, 2024Copper Contributor
Need Help Building a Dynamic Inventory Sheet Formula
Hello! I cannot seem to figure out how to make such an advanced formula work. Could someone with Excel mastery help show me how to nest them properly? I'm looking how to make a formula that c...
jstarbird
May 28, 2024Copper Contributor
Still struggling with this; is it even possible in Excel?
- peiyezhuMay 29, 2024Bronze ContributorI will save all datas in a sheet of database and run sql to retreive relative report.
As to table layout,3 Columns journal is an option rather than keep multiple tables.
https://techcommunity.microsoft.com/t5/excel/formula-to-calculate-daily-balances/m-p/3754060#M182874- jstarbirdMay 29, 2024Copper ContributorThe goal here is to not have to enter the actual inventory more than once. Will that allow me to just type in a table, and have it deduct the entire table contents from current inventory? I'm not familiar with what you mentioned.