+ Reply to Thread
Results 1 to 2 of 2

Repeating pattern problem

  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    United States
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    1

    Repeating pattern problem

    I feel like I have tried everything "index offset indirect" and nothing seems to work.

    Here is my issue

    I have 3 sheets
    First sheet named "group function sheet"
    Second sheet "Group worksheet"
    Third sheet "Decision task sheet"

    I need the information put in the group work sheet to show in the decision work sheet but the cells are 6 off
    example: In the decision worksheet cell T7 needs to equal the cell contents on Group worksheet cell F19
    and then in the decision worksheet cell T8 needs to equal the content in Group worksheet F25

    See its going to be 6 cells off everytime I need to do this in Decision worksheet to cell T5000

    I have tried the indirect formula and it works in the first cell but when I copy it and drag it down the row it just shows the same thing as whats in the cell I copied it from


    Please help

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,962

    Re: Repeating pattern problem

    In cell T7, type

    =INDEX('Group Worksheet'!F:F, (ROW()-4)*6+1)

    and drag down.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. [SOLVED] Pulling data from a repeating cell pattern
    By kevinjay1 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-06-2014, 03:07 PM
  2. Autofill a pattern or repeating sequence
    By awcwa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2013, 12:04 PM
  3. Repeating sequential pattern
    By Bdown in forum Excel General
    Replies: 3
    Last Post: 06-07-2012, 05:13 PM
  4. Excel 2007 : repeating pattern interlinked among columns
    By Blakespops in forum Excel General
    Replies: 0
    Last Post: 10-30-2011, 07:18 PM
  5. formula to copy cells with a repeating pattern
    By jgaynor in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-20-2011, 09:58 AM
  6. Filling a column with a repeating pattern of numbers
    By lam154 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-23-2008, 05:05 PM
  7. [SOLVED] repeating a data pattern in excel
    By KelC in forum Excel General
    Replies: 1
    Last Post: 08-01-2005, 04:05 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