Thread
:
In visual basic
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
In visual basic
Look in the vba help index for FINDNEXT. There is a good example.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Chuck" wrote in message
...
How do i, after pressing a button find a row in sheet 1 which has "Max" in
colum F
Ser Ser No Date Insp Rate Date Next Insp Test Type
Remarks
A001 AG1123 15-04-07 S 15-04-08 Max
A002 AG1265 15-04-07 S 15-04-08 Min
A003 AG1556 17-05-07 S 17-05-08 Anu
A004 AG2314 15-03-07 S 15-03-08 Max
A005 AH435R1 17-07-07 U/S 17-07-08 Anu
and then in sheet 2
Paste the entire row with "Max" in and then find the next blank row and
paste the next entire row with "Max" in from sheet 1 into sheet 2.
there could be 100 rows that have "Max" in and they all need to be copied
and pasted from sheet1 to sheet2.
i have had some help in the past but all i get is errors.
Can any one help?
Many thanks
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett