+ Reply to Thread
Results 1 to 5 of 5

Referencing vertical list horizontally, with gap in cells

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    4

    Referencing vertical list horizontally, with gap in cells

    Hi,

    This is probably something really easy, but I cant for the life of me find the solution on these forums or by googling.

    I am trying to reference a vertical list on another sheet, in a horizontal list every 3 cells.

    Have attached an example example.xls

    Any help would be appreciated

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Referencing vertical list horizontally, with gap in cells

    Hi
    sorry, can't grasp what you are trying to do? When you say " would like this", what is "this" ?
    Last edited by Pepe Le Mokko; 03-11-2013 at 06:55 AM.

  3. #3
    Registered User
    Join Date
    03-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Referencing vertical list horizontally, with gap in cells

    sorry, tried to make an arrow symbol. Was meaning cell d26, g26, j26 etc. would like cell d26 to ref sheet1 g5, g26 to ref sheet1 g6, j26 to ref sheet1 g7 etc

  4. #4
    Registered User
    Join Date
    03-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Referencing vertical list horizontally, with gap in cells

    Any takers?
    Last edited by tercuk; 03-11-2013 at 06:42 PM.

  5. #5
    Registered User
    Join Date
    03-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Referencing vertical list horizontally, with gap in cells

    Can anyone help with this?

+ 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