View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chuck Chuck is offline
external usenet poster
 
Posts: 90
Default visual basic. find copy row past into new sheet

In visual basic

How do i find a row in sheet 1 which has "TEST" in colum K and then in sheet
2 find the next blank row and paste the hole row from sheet 1 into sheet 2.
there could be 100 rows that have "test" in.

Many thanks