Multiplying ALL specified cells of a WORKBOOK by a constant
Posted by philipjsmith on January 03, 2002 11:36 AM
I have a workbook with 15 worksheets with numbers on the same specified cell ranges on each worksheet. I want to create a new Workbook but with all the numbers multiplied by a constant. What is the quickest/easiest way of doing this?
What if the specified cell ranges were different & also different from each other on 5 of these sheets?
Posted by Jacob on January 03, 2002 1:29 PM
Hi
The easiest way would be to put the number you want to multiply by in a cell, copy it, then select all the cells you want to multiply and do a paste special|multiply.
Is this what you want?
HTH
Jacob
Posted by philipjsmith on January 03, 2002 1:57 PM
Do you mean copy to the clipboard? If so how do you select cells from different worksheets simultaneously?
Otherwise this sounds like it will work because when finished I can save the new workbook with an alternative name.
Thanks for your help
Posted by Chris D on January 03, 2002 2:42 PM
over multiple sheets, you'll need to enter this multiplying number before selecting all sheets
so :
right click a sheet and select "select all sheets"
then do as Jacob suggests by copying the multiplying number using "copy", highlight the range (remembering it's the same in all sheets), right click inside the range and select paste special, values and multiply
this should do it
HTH
Chris
