+ Reply to Thread
Results 1 to 3 of 3

Filling down same formulas for 11 rows and filling down another formula same for 11 rows

  1. #1
    Registered User
    Join Date
    12-15-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    4

    Filling down same formulas for 11 rows and filling down another formula same for 11 rows

    For each table I want to fix the same length and width for 11 rows.
    For next table it will be another length and width but is again same for another 11 row
    I need to come out with about 1000 table is there a way to speed up the process instead of changing it manually.

    HTML Code: 

    I also want the to make the main sheet reference to only the first 2 table (green colour)

    instead of 'Length and Width'!O15 it will became 'Length and Width'!O2 when dragging down

    is my idea possible?
    Attached Files Attached Files
    Last edited by ashlawn; 01-06-2013 at 05:50 AM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Filling down same formulas for 11 rows and filling down another formula same for 11 ro

    Change the formula in C3 to:

    =INDEX(TOOLS!$A:$A, ROUNDUP(ROW()/13,0)+3)*'Length and Width'!B2+INDEX(TOOLS!$B:$B, ROUNDUP(ROW()/13,0)+3)*'Length and Width'!O2

    ....then copy that across the first table.

    Now you can copy the entire table and paste below the first, repeat. Each new table will increment to the next set of numbers on the TOOLS page.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    12-15-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Filling down same formulas for 11 rows and filling down another formula same for 11 ro

    Thx it works

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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