View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Quimera Quimera is offline
external usenet poster
 
Posts: 24
Default Summary worksheet reference to detail worksheet

I need to summarize by Division/Item # but I don't know how to refer to
the concatenatation (?) of the two fields on the Summary sheet.

Detail worksheet:
- Column A = Division Column D = Item # Column F = Quantity

Summary worksheet
- Column A = Division Column B - Item # Column D = Summary
Quantity

Can someone help me with this? Sorry I'm still learning, but the last
help I asked for (LOOKUP) - worked like a charm, so I am emboldened to
ask one more question.

Thanks.