Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |