Hello,
First off I should mention that I am a relatively novice Excel user; I can use IF statements and other formulas or formatting but I have no experience with advanced tools such as Macros.
I manage inventory at a manufacturing facility, meaning I coordinate where items are located in our...