+ Reply to Thread
Results 1 to 3 of 3

Unable to extend series.

  1. #1
    Registered User
    Join Date
    06-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Unable to extend series.

    Hello,
    I have a large table I am constructing out of two other tables. The combined table is being built on Sheet 1, while the two tables I'm building it from are on Sheets 2 & 3. I want to pattern to look something like this for the first row of the first sheet (the combined table):

    a1 =Sheet2!a1
    b1 =Sheet3!a1
    c1 =Sheet2!b1
    d1 =Sheet3!b1
    e1 =Sheet2!c1
    f1 =Sheet3!c1

    I tried manually writing out about the first ten cells and filling in the rest. However when I try to extend it, it doesn't follow the desired pattern. Is there some trick to doing this correctly?

    Thank you in advance for your help.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Unable to extend series.

    Which is the last column to be populated?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Unable to extend series.

    In a1

    =INDIRECT("Sheet"&3-MOD(COLUMN(A1),2)&"!"&CHOOSE(ROUNDUP(COLUMN(A1)/2,0),"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z")&"1")

    copy across
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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