Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Macro | Excel Discussion (Misc queries) | |||
Macro for calculating | Excel Discussion (Misc queries) | |||
Macro not calculating correctly | Excel Programming | |||
Macro calculating incorrectly.. what can cause this? | Excel Programming | |||
Calculating Commissions Macro | Excel Programming |