Hi Excel Forum,

Is there a workaround or solution?

I would like to display/ view Criteria based Filtered Visible (Cells
Rows together with specific Non-Filtered (Cells) Rows. Un-Filtere
Data starts in Row 11.

Example:

Un-Filtered Row Data:
Row Grid Ref: 1 2 3 4 5 - 1000 sequentially


Filtered Visible Row Data:
(Based on Advanced Filter Criteria & Filter In-place):
Row Grid Ref: 2 3 6 30 35 50 68 79 85 90 100

Scenario:
I would like to display the Filtered Visible Rows with each Row tha
is sequentially Before (above) it and sequentially After (below) it.
So ultimately, from the sample data above, the Rows displayed would b
Filtered Visible Rows + Rows (sequentially)Before + Rows (sequentially
After the actual Filtered Visible Rows:

Row Grid Ref: 1 2 3 4 5 6 7 29 30 31 34 35 36 49 50 51 67 68 69 78 7
80 84 85 86 89 90 91 99 100 101

Is it possible using VBA to combine the Filtered Visible Rows an
Un-Filtered Rows as mentioned above?

Please advise, if possible assist with a working example.

Kind regards,
QT

--
Message posted from http://www.ExcelForum.com