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
Bookmarks