Hi Guys,

I am trying to write a macro to retain the entire row data between two headers in a particular column.
Could anyone help me on this.

E.g.

Name Age Empl ID Joining Date Status Comments
21-05-2012
BO

Start date


Accept

XYZ XX 1234 03-12-2009 Live PA
PQR XX 5678 09-11-2010 Live PA

Total Accepted

Scottland Entries

Here i just want to keep the entire row data between Accept & Total Accepted wherever it reflects in a particular column.
Any help would be much appreciated.

Many thanks in advance.
Nikki