Hello, I am designing something that will act as an inventory record for a smaller company. Basically, my workbook takes user input (via userforms) that adjusts numbers and allows for a user to view anything that has an inventory other than zero. What I need to do is keep a long term record of every single input that is made with the userforms.
Would this be better done using an additional workbook, an Access file, or simply creating a new worksheet with a pivot table that can adjust what the user wants?
Thanks in advance for any advice!
Bookmarks