+ Reply to Thread
Results 1 to 5 of 5

Copy formula

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    wawsaw
    MS-Off Ver
    Excel 2003
    Posts
    2

    Copy formula

    Hello,

    I have in one cell: A1='companyA'!C11. This cell refer to character. I want to copy this formula down using mouse, but C11 should change by number 63, it should be someting like this:

    A1='companyA'!C11
    A2='companyA'!C74
    A3='companyA'!C137
    A4='companyA'!C200
    etc.

    By default excel change value by 1. Can you help me ?
    Last edited by inferes; 07-18-2013 at 05:04 AM.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Copy formula

    hi inferes, welcome to the forum. try this in A1:
    =INDEX(CompanyA!A:A,63*(ROWS(A$1:A1)-1)+11)

    drag down the formula

    Edit: should be column C:
    =INDEX(CompanyA!C:C,63*(ROWS(A$1:A1)-1)+11)
    Last edited by benishiryo; 07-18-2013 at 05:16 AM. Reason: additional info

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,743

    Re: Copy formula

    Starting in A1 =index('companyA'!$C$1:$C$5000,((row()-1)*63+11))

    ( adapt the range to your needs)

  4. #4
    Registered User
    Join Date
    07-18-2013
    Location
    wawsaw
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Copy formula

    THX, everthing is ok, but I dont now, why I had to change comma to semicolon after $C$5000, because with comma excel showed a mistake.

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,743

    Re: Copy formula

    It's due to your regional settings, good that you spotted it, and bad for me not seeing it

+ 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: 8
    Last Post: 07-08-2013, 06:03 AM
  2. Replies: 3
    Last Post: 01-30-2013, 04:32 PM
  3. make faster copy paste or formula to assist in copy
    By gill389 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2010, 02:07 AM
  4. Copy Formula:copy the exact same formula in one column
    By Leprechaun in forum Excel General
    Replies: 1
    Last Post: 12-11-2006, 07:46 PM
  5. Replies: 10
    Last Post: 03-02-2006, 06:50 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