View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yossy Yossy is offline
external usenet poster
 
Posts: 127
Default Help with Calculating Using Macro Pleaseeeeeeee

I have a workbook with multiple worksheet. For each worksheet in the Wkbook I
want the following to Calculate.

First C162:M163 - Copy content and paste the content as Value
Second For each cell C165:M252 Calculate (C18/c$162)*C$163,
(d19/d$162)*d$163 and so on till (M161/m$162)*m$163
then for each cell C18:M161 Calculate (c18/c$162)*c$13, (d19/d$162)*d$13,
and so on till (M161/m$162)*m$13.
lastly add Cell C18:C161, D18:D161 until M18:M161 and clear content in
C163:M163.

- Note please the calculation is a sample calculation for C18 and d19. I
want the calculation to affect all cells within range specified C18:M161 and
C165:M252, that is why I made row c$162, rowC$13 and Row C$163 absolute.

Please help me in any way possible, I really appreciate all support. Thanks