# Building shopping cart by selecting items from inventory

1. ## Building shopping cart by selecting items from inventory

I would like to create a spreadsheet that does the following:

One tab contains a list of items that are available (an inventory), with each item having values associated with it. There is an option (pull-down) to select x amount of each item to be added to the current list of selected items. I guess this is analogous to shopping online...adding each item to your basket/cart.

On another tab (e.g. your shopping cart), each selected item and the quantity shows up, as well as the stats associated with that item.

I'm sure this is possible to do, but I'm not sure where to start. Any pointers to get me going would be great! I can think of other (less automated) ways to do this, but thought it would be fun to try this.

-----
This is what I plan on doing with this spreadsheet: My inventory will be my hiking/climbing/mountaineering gear. Each item will have other values associated with it (such as weight). For a particular trip, I would want to build essentially a checklist by selecting all the items I want bring on the trip. Other things can be calculated from the selected items such as total weight.

2. ## Re: Building shopping cart by selecting items from inventory

Hi jstluise,

Welcome to the forum.

Would it be possible to share the workbook? Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

3. ## Re: Building shopping cart by selecting items from inventory

I would imagine that VLOOKUP might work

4. ## Re: Building shopping cart by selecting items from inventory

Originally Posted by dilipandey
Would it be possible to share the workbook? Thanks.
I haven't made anything, yet. I was mainly just looking to create a test workbook where I can explore the programming that would accomplish this. I have used Excel quite a bit, not nothing this program intensive.

Originally Posted by royUK
I would imagine that VLOOKUP might work
Thanks! I will take a look.

5. ## Re: Building shopping cart by selecting items from inventory

Attached is a workbook I made up that shows kind of what I am looking for. If someone could take a look and give some feedback, that would be great!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1