+ Reply to Thread
Results 1 to 4 of 4

Copying a formula with fixed rows but different columns

  1. #1
    Registered User
    Join Date
    08-15-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copying a formula with fixed rows but different columns

    Hi,

    Im using this formula in a spreedsheet =(B$3*0,5)+(B$3+(B$4*0,5))+(B$3+B$4+(B$5*0,5))+(B$3+B$4+B$5+(B$6*0,5))+(SUM(B$7:B$28)*4)

    What i want is to be able to drag this down for multiple rows but i want the formula above to only change columns i.e.

    Next row gets C$3 and so on.


    Any help would be great!

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Copying a formula with fixed rows but different columns

    Drag it across the columns and then copy and paste with transpose selected.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Copying a formula with fixed rows but different columns

    How far do you want to copy it to? If less than 26 rows (i.e. equivalent to column Z instead of B), then it is a relatively simple calculation to get the column letter within an INDIRECT function, but every occurrence of B would need such a substitution so your formula would become very long.

    Pete

  4. #4
    Registered User
    Join Date
    08-15-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Copying a formula with fixed rows but different columns

    thank you!

+ 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. how to create a range with fixed columns and changing rows
    By shettyp in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-19-2012, 02:52 AM
  2. Lookup from fixed rows and dynamic columns
    By Alexvs in forum Excel General
    Replies: 2
    Last Post: 11-09-2010, 05:39 AM
  3. Dynamic Range of Columns with fixed Rows
    By nms2130 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-05-2009, 05:24 PM
  4. Force Date Entry with Variable Rows, Fixed Columns
    By rlw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2007, 08:36 AM
  5. Excel 2000 - Fixed size columns and rows?
    By stainless in forum Excel General
    Replies: 2
    Last Post: 07-29-2005, 06:05 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