Code to look at range and extract data.

's Computer Specifications

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.

's Computer Specifications

If I understand you correct ?

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

--

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

"JDJacobs" <(E-Mail Removed)> wrote in message news:5B3B0D6A-CE19-426B-BBB6-(E-Mail Removed)...
> 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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
extract data from a date range	Detin8	Microsoft Excel Misc	2	29th Mar 2010 05:09 AM
RE: extract data from range,and place in the same sheet	joel	Microsoft Excel Misc	0	11th Apr 2009 11:58 AM
VBA Code to extract records between a date range	Daveo	Microsoft Excel Programming	3	21st Sep 2005 08:27 AM
Extract data using a date range	Jonathan Hawkins	Microsoft Excel Worksheet Functions	1	17th Sep 2004 08:06 PM
Data Extract To Range	Ken Wright	Microsoft Excel Worksheet Functions	4	15th Mar 2004 11:22 PM