Shopping list creator

Hi, I'm new to this site, as I have a problem I'm hoping somebody can help with. I'll try and describe in as much detail as possible:

I have created an excel sheet for recipes that my wife and I cook regularly, just the ingredients. I have half achieved my aim to make this produce a shopping list for meals we choose for the week. I say half achieved as each item is listed separately even if there are multiple identical items. For example, the shopping list may call for 2 chicken breasts for Mondays meal, and 2 chicken breasts for Thursdays meal, but what I really want is for it to create a more streamlined list which would just have 4 chicken breasts.

I realise that this is an unsual request, but if anybody can help me out I'd appreciate it. If it would be useful to attach my work in progress, I will do.

Many Thanks,

Dom

also x-posted: http://www.mrexcel.com/forum/showthread.php?t=409807

Not if you x-reference them... else people run the risk of spending free time on something answered elsewhere... (that said forums other than MrE / EF.com are far less tolerant of the practice)

Now that everything is cleared up, I think what you want can be done with SUMPRODUCT but would need to see your spreadsheet layout.

well for a start you need to split
500g Potatoes 4 Spring Onions
into seperate cells
500 potatoes 4 spring onions the key thing is to get numbers seperate
you then need to get an unique list of items from the total shopping list.you could use advanced filter to extract that.
then you could use sumif to get the totals
see attached macro to run advanced filter included!

Thanks for the advice, I'd already starting splitting the ingredients into seperate entries for quantity, unit of measurement and description, and I used a combobox to do this, as I figured it would be pretty important to ensure they are all entered identically (i.e 2 chicken breasts, 2 breasts of chicken).

Now the next step is to alter the macro I had for entering recipes, as it will be taking more values, but more importantly, the values in the combo boxes. The current macro just takes the numerical order on the list, rather than the text it relates to, so my question is, how do i create a macro that automatically moves 69 values from one sheet to another. For example, from (sheet recipe enter) C2:C66, but where a lot of those are combo box entries, to (sheet Recipe Main) next available row.

I'm pretty sure I'm not explaining myself very well, below is the current macro I'm using:

Please Login or Register  to view this content.

Thanks,

Dom

now on that i have no idea sorry ! (ps add code tags or a mod will be after you!)

http://www.excelforum.com/misc.php?do=bbcode#code
basicaly put
[codex]Please Login or Register to view this content.[/code]

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.