Excel Shopping Cart

Take a look at this file

http://www.mediafire.com/view/5cnajc2e2kohxu4/NoMacrosShoppingCart.xlsx

You can download it from that link.

I think this is the way I'd do it - of course making it look a bit nicer.  The key being that you'd set up the "cart" so that the recipient can choose various items on it in one column and the rest of the information for it is provided automatically other than the quantity, which they simply type in. 

You can even really hide the catalog sheet itself so that it doesn't even show up in the list of available sheets to be unhidden.  You have to do that in the VBA editor, but it's easy to do.  If you decide to do something like that and want to really hide the catalog list sheet, then let us know and someone will talk you through how to "Make a Sheet VeryHidden". 

You could get really fancy with it and have color/size/material options if necessary although making those lists appropriate to the main selection is a bit of a trick.  But Debra Dalgleish has some good instructions on how to create dependent lists on her contextures.com website.  Again, we could help with that as separate questions.

Some of these things would work better/easier (for me at least) if we could have macros (VBA code) in the workbook also, but some of your recipients might not know how to enable them to run, or might be wary of a workbook with macros in it from a security standpoint.

I think if you're going to try to do something where a person browses through several other worksheets and picks and chooses items to put into their cart, then you're almost going to be forced to include macros as part of the package.

hi just seen this online and its very good

just a question how can i edit it to make it for songs

require more listing in the catalog but rather a dropdown menu can i use like a add button on the catalog sheet  to put it on the shopping cart 

thanks in advance

\david

Take a look at this file

http://www.mediafire.com/view/5cnajc2e2kohxu4/NoMacrosShoppingCart.xlsx

You can download it from that link.

I think this is the way I'd do it - of course making it look a bit nicer.  The key being that you'd set up the "cart" so that the recipient can choose various items on it in one column and the rest of the information for it is provided automatically other than the quantity, which they simply type in. 

You can even really hide the catalog sheet itself so that it doesn't even show up in the list of available sheets to be unhidden.  You have to do that in the VBA editor, but it's easy to do.  If you decide to do something like that and want to really hide the catalog list sheet, then let us know and someone will talk you through how to "Make a Sheet VeryHidden". 

You could get really fancy with it and have color/size/material options if necessary although making those lists appropriate to the main selection is a bit of a trick.  But Debra Dalgleish has some good instructions on how to create dependent lists on her contextures.com website.  Again, we could help with that as separate questions.

Some of these things would work better/easier (for me at least) if we could have macros (VBA code) in the workbook also, but some of your recipients might not know how to enable them to run, or might be wary of a workbook with macros in it from a security standpoint.

I think if you're going to try to do something where a person browses through several other worksheets and picks and chooses items to put into their cart, then you're almost going to be forced to include macros as part of the package.

It's not for oneline purpose.  Just in excel to send third parties.

Where is this going to be used: online or not?  Lots of things that might be used (such as macros) to make a really nice cart can't be used as a WebApp.  Excel would be a rather poor choice for an online cart.

If not online, are you going to have to deal with things like multiple selection of the same item but in different sizes/colors/materials?

Sorry forgot to mention I have excel 2007.