+ Reply to Thread
Results 1 to 5 of 5

Building shopping cart by selecting items from inventory

  1. #1
    Registered User
    Join Date
    03-17-2012
    Location
    WA, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    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. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    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>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Building shopping cart by selecting items from inventory

    I would imagine that VLOOKUP might work
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    03-17-2012
    Location
    WA, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Building shopping cart by selecting items from inventory

    Quote Originally Posted by dilipandey View Post
    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.

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

  5. #5
    Registered User
    Join Date
    03-17-2012
    Location
    WA, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    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!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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