View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RichardOnRails RichardOnRails is offline
external usenet poster
 
Posts: 4
Default Posting in each row of a Summary sheet the sum of corresponding itemson another sheet

Hi,

I don't know much about VBA (though I've done a lot of C++, Ruby,
etc.). I've got a Summary sheet and a Details sheet.

Each row in the Summary sheet has (Cols A, B, C, etc) = ProdID ,
ProdName, #Items, etc.

Each product in the Details sheet has a 3+ rows with:
- 1st row, Col. A, = ProdID
Col B of the 1st, 2nd, etc. rows = # items of that product received
Col C of the 1st, 2nd, etc. rows = date of each receipt
etc.

I'd like to specify the the # items in each row of the Summary sheet =
Sum(the of the #Items in the corresponding Details rows.

Is there some online writeup about how this could be done? Or can you
provide the key ideas about how this search could be coded in VBA?

Thanks in Advance,
Richard