Design For New Workbook

[dylcon]

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!

[scott.s.fower]

in your user form code you can have it put a time stamp, is that what you're asking? I think i need a bit more info before i can give you the answer that you deserve

you need a record of every single input, meaning track when a user inputs form data as a whole, or each individual entry into the form, so if i entered 10 for the quantity then realized it should have been 11 before i submit the form it will track both?

[dylcon]

A time stamp would be helpful, yes, but that is not the ultimate goal. It is set up so in your example, a corrective input of 11 would be a different type of input and I would like it to say so, which I know how to do. I am more focused on whether I should have the workbook linked to an access file or possibly another workbook. If I am doing a pooor job explaining, I can upload my workbook, with a better explanation....
Thank you for your contribution though, I appreciate it.

[scott.s.fower]

I would say that it would be better to have the change log be in a separate file either excel or access. I say this only as a precaution so someone can't change the data to "cover his/her tracks". if you are not worried about a user changing the change log then it would be fine to use a separate worksheet as your change log

[dylcon]

Even though there are approximately 50 companies with anywhere from 1 to 100 parts each? I am afraid of the file becoming too large? Is 1.5 MB too big to be functioning correctly?

[FDibbins]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.