+ Reply to Thread
Results 1 to 3 of 3

Copying a basic formula to multiple cells in a column, while keeping the source cell

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    Eston, South Africa
    MS-Off Ver
    Office 2007
    Posts
    2

    Copying a basic formula to multiple cells in a column, while keeping the source cell

    Hi folks

    I am busy doing a price list for a product we import. I need to multiply each price by a number contained in a cell to work out my landed cost.


    To elaborate:

    I have a value in Cell D8 that is my multiplier for customs and Tax. Each price on the price list needs to refer to this cell to give me a total in the corresponding cell in column G.

    IE: =F13*D8, =F14*D8, =F15*D8 etc

    When I try copy the first one (=F13*D8) to the cells in G column, it keeps changing the D8.

    IE: =F13*D8, =F14*D9, =F15*D10

    How do I copy / paste so that it keeps the reference to D8, but changes the F numbers?

    I hope I have been clear enough in my explanation!

    Thanks for the time

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Copying a basic formula to multiple cells in a column, while keeping the source cell

    It seems like you need a basic absolute reference -- one of those first things to learn about spreadsheet programming. "$" before the column letter and or row number makes that part of the reference absolute, and a "$" before both column letter and row number makes both absolute. So use something like =F13*$D$8. I'd recommend that you spend some time with something like this to review the behavior of different types of references: https://support.office.com/en-us/art...e-5f0d8d0baca9
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    01-11-2019
    Location
    Eston, South Africa
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: Copying a basic formula to multiple cells in a column, while keeping the source cell

    MrShorty, thank you sir!!

    Works perfectly
    Last edited by MartinKZN; 01-11-2019 at 11:06 AM.

+ 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. Replies: 0
    Last Post: 08-07-2015, 08:44 PM
  2. Replies: 3
    Last Post: 06-28-2014, 07:04 AM
  3. [SOLVED] Copying the formula horizontaly keeping the same column but changing row number
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2014, 02:05 PM
  4. Copying over cells from one sheet to the next and deleting orginal cell source
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-27-2013, 07:54 AM
  5. Create new worksheet keeping source column widths
    By maimden in forum Excel General
    Replies: 1
    Last Post: 04-12-2013, 08:03 PM
  6. Replies: 1
    Last Post: 03-04-2012, 12:03 AM
  7. Replies: 0
    Last Post: 11-15-2007, 02:37 AM

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