View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hafeez Esmail Hafeez Esmail is offline
external usenet poster
 
Posts: 22
Default 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