From: JDJacobs on
If the column of data has the text "Back On" I want to copy the adjacent
columns to another sheet for each instance. This will be a loop since this
text occurs more than once.
From: Ron de Bruin on
If I understand you correct ?

Start here
http://www.rondebruin.nl/copy5.htm




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"JDJacobs" <JDJacobs(a)discussions.microsoft.com> wrote in message news:5B3B0D6A-CE19-426B-BBB6-F68B9AD6C2DB(a)microsoft.com...
> If the column of data has the text "Back On" I want to copy the adjacent
> columns to another sheet for each instance. This will be a loop since this
> text occurs more than once.