Posted to microsoft.public.excel.programming

Gordon[_2_] Gordon[_2_] is offline

external usenet poster

Posts: 211

Selective paste

Hi..

I have a block of data A9:10000 - X9:10000. Is there any code that would
allow me to select any combination of rows in which the word 'aged' is found
and then to compact them into a new sheet? For example, if the word 'aged' is
only found on 130 random rows then those 130 are pasted into a new sheet as
one block of text.

Any help would be appreciated...

Thanks G

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selective on Name	stew	Excel Discussion (Misc queries)	5	September 14th 08 07:53 PM
Selective calculation	PH NEWS	Excel Worksheet Functions	2	September 21st 06 01:33 PM
SELECTIVE DELETE	[email protected]	Excel Programming	2	June 15th 06 10:46 PM
Selective Data	MattD	Excel Programming	3	October 28th 05 07:49 PM
copy / paste selective rows	Kenny Kendrena via OfficeKB.com	Excel Discussion (Misc queries)	5	February 7th 05 12:55 PM

All times are GMT +1. The time now is 01:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us