How do I copy multiple cells and paste special them on multiple cells?
for example:
A...........B........................C
10..........=A1*2=20...........2
13..........=A1+5=18..........3
16..........=A1/2=8.............4
Copy & paste special C1:C3 to B1:B3, so the result will be:
B
=(A1*2)*2 = 40
=(A1+5)*3 = 54
=(A1/2)*4=32
In my spreadsheet columns B and C contains Formulas. I need to update the formula in column B, so it will be multiplied by what I have in column C.
I can't add another column to the spreadsheet (it must be in this specific format because it's imported to other software).
There are many rows and I can't do it one by one.
Someone can help me?
Bookmarks