Results 1 to 10 of 10

Skip Multiple Rows when copying formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    USA, USA
    MS-Off Ver
    Excel 2010
    Posts
    14

    Skip Multiple Rows when copying formula

    PLEASE HELP!!!!!

    New to forum - much appreciation in advance.

    I have a linked formula tying spreadsheets together. The layout of the second sheet is different than that of the base sheet so I need to formula to skip 3 rows at a time from the base sheet.

    Here is the linking formula in column B of the second sheet:
    ='[Inventory PLUS.xlsx]Sheet1'!A5


    In the very next row of the second sheet I need it to pull from 3 rows down from the base sheeet (A8), or more precisely ='[Inventory PLUS.xlsx]Sheet1'!A8

    In the next subsequent rows I need the formula to pull from (A11,A14,A17) always adding 3 rows from the base sheet each row moved down on the second sheet.

    So, in essence I want my B column to go as followed:
    B1 ='[Inventory PLUS.xlsx]Sheet1'!A5
    B2 ='[Inventory PLUS.xlsx]Sheet1'!A8
    B3 ='[Inventory PLUS.xlsx]Sheet1'!A11
    B4 ='[Inventory PLUS.xlsx]Sheet1'!A14

    and so on and so fourth, continuing down the sheet as there are a lot of different inventory and I am always adding more parts.

    - If you have any input, it would be greatly appreciated.

    Being that this is my first post I know I may have to explain better but any info you could send me would be greatly appreciated.
    Last edited by rbexcel; 07-26-2013 at 01:16 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel formula skip rows help!
    By crash884 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-19-2013, 08:15 AM
  2. Replies: 0
    Last Post: 11-08-2012, 01:07 PM
  3. Formula/Macro for copying, skip empty cells
    By joscar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2011, 06:04 PM
  4. Formula issue: multiple rows referencing one row-copying
    By jakrabbit in forum Excel General
    Replies: 2
    Last Post: 10-28-2010, 09:09 AM
  5. skip 'n' rows when copying formula
    By mksnyder in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-08-2007, 02:53 PM

Tags for this Thread

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