LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default finding and then moving entire row to new sheet based on cell value

I have a sheet with several thousand rows that looks something like this:

name address city search-term

I want to be able to "search" the search-term column for a key word and then move entire row to a new sheet

There are several examples here I have tried none seem to do above!

Thanks for any guidance.

Dave

EggHeadCafe - Software Developer Portal of Choice
Using COM-Callable Wrappers to Extend Visual Basic 6.0
http://www.eggheadcafe.com/tutorials...le-wrappe.aspx
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Copy entire row to another sheet based on a criteria Brig Siton Excel Discussion (Misc queries) 3 August 7th 06 09:04 PM
Moving An Entire Row From One Sheet To Another M.A.Tyler Excel Discussion (Misc queries) 9 May 2nd 06 12:56 PM
Finding the value of a cell in an entire worksheet Jon Excel Worksheet Functions 7 February 7th 06 06:02 PM
Moving rows from one sheet to another based on a particular cell v mm Excel Discussion (Misc queries) 0 November 11th 05 06:29 PM
Moving cursor to another cell w/out selecting entire area Darin Excel Discussion (Misc queries) 8 May 13th 05 08:44 PM


All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"