+ Reply to Thread
Results 1 to 2 of 2

Macro to multiply entire row by a fix given number

Hybrid View

  1. #1
    Registered User
    Join Date
    02-26-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    3

    Macro to multiply entire row by a fix given number

    Please see the spreadsheet. I need a macro which multiplies the figures enterd in row

    B5 to Q5 * 50
    B6 to Q6 * 20
    B7 to Q7 * 10
    B8 to Q8 * 5

    what usually we do is input figures in these columns in all the sheets where it shows till no. can we do a macro which does for all the sheets named
    Attached Files Attached Files
    Last edited by buchumang; 06-06-2014 at 04:56 AM. Reason: added spreadsheet

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to multiply entire row by a fix given number

    You can type the number you want to multiply by (Let's say 50 in column E1) and run this code. It will multiply by E1 values all rows (1-4).

    Option Explicit

    Sub Macro1()
        Range("E1").Copy
        Rows("1:4").PasteSpecial xlPasteAll, xlMultiply
        Application.CutCopyMode = 0
    End Sub

+ 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] Macro adds number to entire selection, how to avoid adding to blank cells?
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2014, 03:05 PM
  2. Replies: 3
    Last Post: 04-06-2012, 02:25 PM
  3. [SOLVED] how do i multiply entire columns of numbers by a %
    By stgaw53 in forum Excel General
    Replies: 1
    Last Post: 10-26-2005, 02:05 PM
  4. [SOLVED] how do I divide or multiply an entire column?
    By 1number in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2005, 05:07 PM
  5. multiply entire column by a number
    By ludarabota in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-03-2005, 02:55 PM

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