H
Hafeez Esmail
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. I'm now left with a range.
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?
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)?
Any help would be appreciated
Hafeez Esmail
Section, Code, Date and Time
I sort the data (Code, Date, Time) and then filter it so
I'm left with one Section. I'm now left with a range.
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?
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)?
Any help would be appreciated
Hafeez Esmail