Hello Wizards.

I'm an extreme novice on excel and I'm hoping there's an easy fix for my problem.

Essentially my company has a database of all the components we need to manufacture a range of products. What we would like to do is make this database in to a kind of shopping list where we can simply click certain components and they will be automatically added to another document or workbook like a "shopping list". However the idea would be to have all the components selected added to one new page so we would have a list of all the components needed for that product.

I know there are easier ways to go about this (such as having a database for each product or simply copy and pasting into another doc.) but many of the people who would have access to this database are not very computer savvy (as well as being uber lazy) and the main issue is that our products are bespoke so some components may feature in 50 different end products.

Hope I've explained that OK and any advice would be greatly appreciated.
Many Thanks
P.Titan