+ Reply to Thread
Results 1 to 3 of 3

Pick data from another sheet in specific row intervals

  1. 11-22-2013, 12:54 AM #1
    electrophile
    electrophile is offline
    Registered User
    Join Date
    11-22-2013
    Location
    US
    MS-Off Ver
    Excel 2013
    Posts
    2

    Pick data from another sheet in specific row intervals

    I have a sheet that picks values from a different sheet (raw data sheet). Best to show through an example.

    Col1
    Row1 [anothersheet.xlsx]Sheet1!$B$14
    Row2 [anothersheet.xlsx]Sheet1!$B$141
    Row3 [anothersheet.xlsx]Sheet1!$B$268
    . .
    . .
    . .

    Each next row in the current sheet needs to pick data from the the next 127th row of the data sheet. Is there a way to do this simplistically without any programming? Right now its just one column but there will be other columns added soon and they'll show data the same way.
    Reply With QuoteRegister To Reply
  2. 11-22-2013, 01:01 AM #2
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Pick data from another sheet in specific row intervals

    welcome to the forum, electrophile. different sheet means same file/workbook. so there shouldn't be .xlsx.
    =INDEX(Sheet1!B:B,14+(ROWS($1:1)-1)*127)

    if you meant different file/workbook, then:
    =INDEX([Book1]Sheet1!B:B,14+(ROWS($B$1:$B1)-1)*127)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."

    Tips & Tutorials I Compiled | How to Get Quick & Good Answers
    Reply With QuoteRegister To Reply
  3. 11-22-2013, 03:08 AM #3
    electrophile
    electrophile is offline
    Registered User
    Join Date
    11-22-2013
    Location
    US
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Pick data from another sheet in specific row intervals

    Thanks benishiryo! That certainly helped!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pick up data from the sheet
    By ALEZI in forum Excel General
    Replies: 2
    Last Post: 06-11-2013, 03:35 PM
  2. To transfer data from one sheet to another four sheets and also to pick up the higher pric
    By Harrold in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2012, 08:59 AM
  3. pick data from first sheet & update other sheets.
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-22-2010, 06:24 AM
  4. pick data from a specific row/column (eg 10/B) related to active cell
    By zonino in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2009, 04:01 PM
  5. Pick up and Calculate specific data
    By WLM1976 in forum Excel General
    Replies: 5
    Last Post: 11-18-2006, 08:57 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1