Thank you so much for the help. That definitely fixed my issue. I'm now trying to make it a bit more robust and was wondering if you could give insight into another issue that I want to address with the sheet. My next goal is to have certain categories of products (laptops, desktops, monitors, and printers) scan and update the product count (as it's already set to do), but also bring up a custom form that then outputs the information from the form to an Access database. For example when I scan the laptop SKU it allows me to update the count, but then also loads a form asking for the following:
1. Laptop Serial Number
2. Model
3. Owner (person entering the info)
4. The date
5. Any Comments
I should have no issue creating the form itself, but I have no idea if it's possible to push out the form results directly to access instead of having it make a sheet in excel and then just export it to Access. I also don't know if it's possible to have excel distinguish between SKUS that will need to load the form (I was originally thinking of adding in a simple yes/no box for the user to indicate if they need to use the form).
Bookmarks