Form front end

[nothingbutdan]

Hey all!

I hope you are all well and had a cracking weekend! I need a helping hand, my partner needs to create an excel spreadsheet to manage all products that are in a particular room in a lab. she created this however people arnt really using it, and someone mentioned "why dont you create a form front end to make it look nicer". So she now want to do that, but I have NO idea how to do it.
So whats need is:
- A spreadsheet to see what is currently in that room
- A form front end to ADD and MINUS products (bare in mind that no products the same so cant have a drop down box) i.e a user has a field that they type in a SKU then it finds it on the spreadsheet and either deletes it or adds depending what the user selected on the front end.
- Search to see if a particular product is in that room
Is that possible if so how?
Thanks in advance for any help,
Kindest regards,
Dan

 

[mumps]

It would be easier to help if you could set up the first sheet containing all the products and then use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of that sheet. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.