+ Reply to Thread
Results 1 to 5 of 5
  1. March 1st, 2009, 11:14 AM #1
    Gavin Harris
    Gavin Harris is offline
    Junior Member
    Join Date
    Mar 2009
    Posts
    2

    Question look up vissable cells only after a row #

     
    IN EXCEL, i want to return data from the first cell in a column..... i am using a pulldown button halfway down a column that chooses the cells with the data that i wish to display. ie. th row numbers down the side of the page might stop at say 25 where the pull down button is, then there is data in all the cells in that column from 26 to 400. when i select the types of info to display with the pulldown button, some of the row numbers will be hidden to only show the data required. i want to retrieve the data from the first row number cell that is visable wether it is number 26 or number 54 ect and show it in another cell elsewhere.
    Last edited by Gavin Harris; March 1st, 2009 at 12:18 PM.
    Reply With Quote Reply With Quote
  2. March 1st, 2009, 11:52 AM #2
    Steve R Jones
    Steve R Jones is offline
    Ride 'em Cowboy Steve R Jones's Avatar
    Join Date
    Oct 2001
    Location
    Dallas, TX
    Posts
    12,375
    Is this maybe in EXCEL?
    Imagine a world where dogs took bad owners to the pound...
    Reply With Quote Reply With Quote
  3. March 1st, 2009, 12:19 PM #3
    Gavin Harris
    Gavin Harris is offline
    Junior Member
    Join Date
    Mar 2009
    Posts
    2
    Quote Originally Posted by Steve R Jones View Post
    Is this maybe in EXCEL?
    yep changed now, thx
    Reply With Quote Reply With Quote
  4. March 1st, 2009, 12:36 PM #4
    surreal
    surreal is offline
    Indispensable Member surreal's Avatar
    Join Date
    Oct 2001
    Location
    Meechigan
    Posts
    30,892
    Send a message via ICQ to surreal Send a message via AIM to surreal Send a message via Yahoo to surreal
    YOu might need to wait for a member called Epidemic to come online.
    Or you might want to send him a Private Message, he is our resident excel expert.
    "Sometimes life is just what we make it."
    Reply With Quote Reply With Quote
  5. March 1st, 2009, 02:40 PM #5
    vass0922
    vass0922 is offline
    Not Really a Member
    Join Date
    Oct 2001
    Posts
    27,856
    I dont believe you'll find a builtin method for this, I'd venture to guess it would require a macro or a bit of VBA to accomplish
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PHP Help - Delete row
    By Rand Dusing in forum Webmastering and Programming
    Replies: 2
    Last Post: August 8th, 2006, 12:56 PM
  2. Row height differences in IE and FF
    By Super Nick in forum Webmastering and Programming
    Replies: 1
    Last Post: July 18th, 2006, 01:38 PM
  3. Two bad 6600GT's in a row???
    By DanU in forum Graphics Cards and Displays
    Replies: 5
    Last Post: February 13th, 2006, 11:14 PM
  4. Double-Row RAM?
    By Kc2iLq in forum General Tech Discussion
    Replies: 8
    Last Post: February 6th, 2003, 10:11 PM

Tags for this Thread

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Recommended Sites: ResellerRatings Store Reviews