March 1st, 2009, 11:14 AM #1
- Join Date
- Mar 2009
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.
March 1st, 2009, 11:52 AM #2
Is this maybe in EXCEL?Imagine a world where dogs took bad owners to the pound...
March 1st, 2009, 12:19 PM #3
March 1st, 2009, 12:36 PM #4
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."
March 1st, 2009, 02:40 PM #5
- Join Date
- Oct 2001
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Rand Dusing in forum Webmastering and ProgrammingReplies: 2Last Post: August 8th, 2006, 12:56 PM
By Super Nick in forum Webmastering and ProgrammingReplies: 1Last Post: July 18th, 2006, 01:38 PM
By DanU in forum Graphics Cards and DisplaysReplies: 5Last Post: February 13th, 2006, 11:14 PM
By Kc2iLq in forum General Tech DiscussionReplies: 8Last Post: February 6th, 2003, 10:11 PM