Forum Discussion
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...
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.