Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search, Copy & Paste Formula
Hi! I am trying to create a formula that will seach a specific column for a
certain word within a text string and if the word is present to copy the row and paste it in a new worksheet. Any ideas? I need to search Column E for the word "enterprise" and if found I need to copy the entire row and its data into a new worksheet. Currently have 33919 rows to check, any help would be greatly appreciated! Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search, Copy & Paste Formula
Have you thought about using Autofilter on column E? Set it for Custom, then
"Contains" (scroll down to see this) and then the word enterprise. You can highlight the visible cells, click on <copy, and then paste them to another sheet - all done in one operation. Hope this helps. Pete "chanse25" wrote in message ... Hi! I am trying to create a formula that will seach a specific column for a certain word within a text string and if the word is present to copy the row and paste it in a new worksheet. Any ideas? I need to search Column E for the word "enterprise" and if found I need to copy the entire row and its data into a new worksheet. Currently have 33919 rows to check, any help would be greatly appreciated! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't copy/paste the formula | Excel Discussion (Misc queries) | |||
Search, copy and paste help | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
VBA-code for search,copy and paste | Excel Discussion (Misc queries) |