I would like to create a macro to copy information from different worksheets
to one single worksheet, and add the values associated with them together. I
know this is a little vague, but it is pretty hard to explain, though I will
try. I have a workbook that contains many different worksheets, all with
menu cost analysis information in them, each worksheet is for a different
menu category and time of day (apps, entrees, lunch, dinner, etc.) Each
worksheet has the same format. The first column contains an ID number so
that other macros can use the information. The second column contains the
name of the item. The third column is the number of items sold and the sixth
column is the total cost for the item. (The fourth and fifth columns aren't
necessary but can't be deleted. I would like to create a macro that copies
the item names, number sold and total cost to a separate worksheet, but if
there are duplicates of the item on different sheets, to be able to just add
the number sold. Does this make any sense? Is this even possible? The
reasoning is that I would like to create the ideal food cost which is the
total cost of all the items sold times the total number of items sold,
divided by by total food sales, which would be entered separately. Someone
please help.

Thanks

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Harlan" <(E-Mail Removed)> wrote in message
news:11C36E91-3274-4756-81EF-(E-Mail Removed)...
>I would like to create a macro to copy information from different
>worksheets
> to one single worksheet, and add the values associated with them together.
> I
> know this is a little vague, but it is pretty hard to explain, though I
> will
> try. I have a workbook that contains many different worksheets, all with
> menu cost analysis information in them, each worksheet is for a different
> menu category and time of day (apps, entrees, lunch, dinner, etc.) Each
> worksheet has the same format. The first column contains an ID number so
> that other macros can use the information. The second column contains the
> name of the item. The third column is the number of items sold and the
> sixth
> column is the total cost for the item. (The fourth and fifth columns
> aren't
> necessary but can't be deleted. I would like to create a macro that
> copies
> the item names, number sold and total cost to a separate worksheet, but if
> there are duplicates of the item on different sheets, to be able to just
> add
> the number sold. Does this make any sense? Is this even possible? The
> reasoning is that I would like to create the ideal food cost which is the
> total cost of all the items sold times the total number of items sold,
> divided by by total food sales, which would be entered separately.
> Someone
> please help.
>
> Thanks
>
>