View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default match and copy data

Hi,
You could use Data==Filter ==Autofilter from Excel toolbar.

Select the columns, and for "Mod" column, click on the arrow, select
"Custom" and in the next message box, in "Show rows where" box value is
"Begins with" and value in the ajoining box is "IT" (no quotes required).
Click OK.

Then copy and paste these selected rows to your new worksheet.

HTH

"new_to_vba" wrote:


there's so many experts here..
yet no 1 able to help?


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=510440