Results 1 to 3 of 3

Thread: Copy formula over eight columns
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Copy formula over eight columns

    I a worksheet that I am comparing Actua,Budget, Forecast, and PY for each day of he month. I have the raw data for each in it's own tab. I have the below formula that I need to copy over eight columns each time, thus when I copy over eight columns it changes the C to K but I want it to change to D instead and so forth.
    (Actual!C170+Actual!C174)/Summary!H10
    .

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,375
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Copy formula over eight columns

    Welcome to the Board!

    I don't think your question is entirely clear. Maybe it will make more sense if you walk us through some examples, i.e.
    - What cell is the original formula in?
    - What does the original formula look like?
    - What cell should the formula be copied to?
    - What should the formula look like after being copied to this cell?
    - How many times does this need to be copied (how do we know when to stop)?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,917
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    10 Thread(s)

    Default Re: Copy formula over eight columns

    I guess you have the formulas in C and in K, try this

     ABCK
    1    
    2  35

    CellFormula
    C2=(OFFSET(Actual!$C170,,MOD(COLUMN()+5,7)-1) + OFFSET(Actual!$C174,,MOD(COLUMN()+5,7)-1)) / Summary!H10
    K2=(OFFSET(Actual!$C170,,MOD(COLUMN()+5,7)-1) + OFFSET(Actual!$C174,,MOD(COLUMN()+5,7)-1)) / Summary!P10


    In the formula of cell K2 you see $ C, but you're really getting the value from column D
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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