Forum Discussion
Mikal65
Jan 22, 2024Copper Contributor
Formula for material inventory tracking
I have a material consumption sheet with Materials represented in the lines and projects in columns. The projects are listed by date so that the further I go to the right the more material consumptio...
mathetes
Jan 24, 2024Gold Contributor
Frankly, that sounds like a spreadsheet that needs to be redesigned so as to take advantage of Excel more fully, letting IT (Excel) do more of the work for you. Would you be willing to share the file--so long as it contains no confidential information--so some of us can take a look at it and make suggestions?
Post it on OneDrive or GoogleDrive with a link pasted here that grants access to it.