+ Reply to Thread
Results 1 to 6 of 6

Copy multiple cells and paste special them on multiple cells

  1. #1
    Registered User
    Join Date
    10-31-2019
    Location
    Israel
    MS-Off Ver
    2010
    Posts
    3

    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. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,006

    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?
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    10-31-2019
    Location
    Israel
    MS-Off Ver
    2010
    Posts
    3
    Quote Originally Posted by PaulM100 View Post
    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. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,006

    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. #5
    Registered User
    Join Date
    10-31-2019
    Location
    Israel
    MS-Off Ver
    2010
    Posts
    3

    Re: Copy multiple cells and paste special them on multiple cells

    Quote Originally Posted by PaulM100 View Post
    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. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,126

    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.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy Multiple Cells from Multiple Sheets and paste them in Master Sheet
    By Ravana in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2018, 07:30 AM
  2. Replies: 14
    Last Post: 04-18-2017, 07:07 PM
  3. Copy and Paste Multiple Cells()
    By bbmak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2014, 08:41 PM
  4. [SOLVED] Copy Filter Data and paste it on another workbook with special cells(Only Visible Cells)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-13-2014, 07:59 AM
  5. Replies: 0
    Last Post: 07-10-2006, 04:34 PM
  6. How to copy and paste same formula in multiple cells?
    By Amanda in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. [SOLVED] How to copy and paste same formula in multiple cells?
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1