View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
krc547 krc547 is offline
external usenet poster
 
Posts: 28
Default Macro to summarize data

I need a macro to look at worksheet "Mar 08" starting in Column "C6" look
down the column and if there is a 0,1,2,3,4 the return the amount in column
"G" to worksheet "Summary" starting in column "C6" fill down, then look at
the same worksheet and if there is a 5,6,7,8 then look at column "G6" and
place the answer in worksheet "Summary" starting at column "G6" and so on
until 0 - 18 as been recorded on the summary sheet.