Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigating a filtered list
I have a tonne of data with 4 key columns;
Section, Code, Date and Time I sort the data (Code, Date, Time) and then filter it so I'm left with one Section. Since the first Row is always blank (and I need it to be), how do I do the following: Select the SECOND visible Cell in Column A? (the first being a blank row) Select the NEXT visible Cell in Colun A? Let's say I want to keep the Second visible cell in Column A as the selected cell. How do I do the following? Get data in Column D (same row as the selected cell)? Get data in Column D (next visible row from selected cell)? Hafeez Esmail P.S. This has been posted before but my question wasn't quite answered correctly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A list of what is being filtered on? | Excel Discussion (Misc queries) | |||
charting a filtered list | Excel Discussion (Misc queries) | |||
Return Value from a Filtered List | Excel Worksheet Functions | |||
Navigating in filtered rows | Excel Discussion (Misc queries) | |||
Counting a Filtered List | Excel Discussion (Misc queries) |