+ Reply to Thread
Results 1 to 2 of 2

Cells repeating

  1. #1
    Forum Contributor
    Join Date
    05-19-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    111

    Cells repeating

    Hi
    I excel suppose in Column A i type A, B,C,D in different cells, in the next sheet in Column A i want thease to be repeated till the number of cells we mention. Like A,B,C,D again start with A,B,C,D and it continues .
    And in next lot i want this A,B,C,D to be replaced with R,T,U,I,O,P,H. Then thease needs to be repeated.
    Is it ppossible

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,861

    Re: Cells repeating

    Put this formula in A1 of Sheet2:

    =INDEX(Sheet1!A:A,MOD(ROWS($1:1)-1,COUNTA(Sheet1!A:A))+1)

    then copy down as far as you need to.

    I'm not sure what your second question means, but if you put R,T,U,I,O,P,H in cells A1:A7 of Sheet1, then the display on Sheet2 will automatically adjust.

    Hope this helps.

    Pete

+ 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] Repeating an ID in multiple cells dependent on another cells value
    By Georgia1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2013, 02:54 PM
  2. creating a repeating formula that doesn't show repeating values
    By cybershot in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-09-2010, 06:12 PM
  3. Help - Repeating Code and moving Cells
    By Bob316 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2010, 09:37 AM
  4. Formatting repeating cells
    By Winterburn in forum Excel General
    Replies: 7
    Last Post: 01-02-2010, 04:44 AM
  5. [SOLVED] repeating cells in footer in excel
    By Dogu Tumerdem in forum Excel General
    Replies: 0
    Last Post: 08-03-2005, 05:05 AM

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