+ Reply to Thread
Results 1 to 2 of 2

Looking to be able to select specific rows and columns and display only those selections

  1. #1
    Registered User
    Join Date
    08-29-2014
    Location
    New York, NY
    MS-Off Ver
    2013
    Posts
    1

    Looking to be able to select specific rows and columns and display only those selections

    I'm trying to set up a data analysis worksheet that has specific row and column headings. I want to be able to select the row/column and display that on a separate sheet, but only the selected value of each row and column.

    For example, if I have rows 1,2 ,3, 4, 5 and columns a,b,c,d,e, I want to be able to select row 1,3,4 and column c,d,e and display just those values on a separate linked sheet. I would be able to change the rows/columns selected.
    Originally i tried this with checkboxes, but ran into a lot of trouble with embedding them into the worksheet and having them reference an entire row/column. I also tried the pivot table, but it was very clunky.

    Any insight is greatly appreciated.

    CJ

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Looking to be able to select specific rows and columns and display only those selectio

    Use INDIRECT
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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. select numbers in columns and display them in other lines
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-31-2013, 04:58 PM
  2. Select Random Rows and Display on new sheet
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 02-27-2013, 06:54 AM
  3. [SOLVED] If I select an option from a drop-down in 1 cell, how do i get it to display specific info
    By Posthuman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2012, 01:45 PM
  4. Code to prevent user to Select COLUMNS but allow to select ROWS
    By tengrosita in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2011, 03:46 AM
  5. select specific rows
    By Paulg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2006, 01:15 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