# Copy multiple cells and paste special them on multiple cells

1. ## Copy multiple cells and paste special them on multiple cells

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?

2. ## Re: Copy multiple cells and paste special them on multiple cells

Do you have formulas in C1:C3 with references to columns A or B?

3. Originally Posted by PaulM100
Do you have formulas in C1:C3 with references to columns A or B?
No.
C has formulas with references to other columns. Not A or B.

4. ## Re: Copy multiple cells and paste special them on multiple cells

So in B column you already have formulas like =(A1*2), =(A1+5) and you want to multiply them by C column values without helpers?

5. ## Re: Copy multiple cells and paste special them on multiple cells

Originally Posted by PaulM100
So in B column you already have formulas like =(A1*2), =(A1+5) and you want to multiply them by C column values without helpers?
Yes. What I wrote is the current worksheet.
I need to multiply the formula in B by the cells in C

When I do paste-special-multiply it takes only C1 and not all the the cells in C.

6. ## Re: Copy multiple cells and paste special them on multiple cells

This may be off topic but A1+5 is not 18. A1+5=15
By the same token A1/2=5 not 8
is the formula in B2 supposed to be =A2+5 and is B3 suppose to be =A3/2?
Not saying that we can solve, however we may have a better chance of helping if you upload the spreadsheet (instructions in 4th banner at the top of page).
Let us know if you have any questions.

There are currently 1 users browsing this thread. (0 members and 1 guests)