I am sure Norman, however at the end of the day learning basic spreadsheet
skills (I would have been done with the above in under 30 seconds
GUARANTEED) some one-off issues of this simple nature are better handled
through solid spreadsheeting skills than macro writing.

It's just my humble opinion, I did not say the macro was complicated. So I
am glad if Tom or you were able to help Tahir with a macro.

Bill


"Norman Jones" wrote in message
...
Hi Bill,

This is better than writing a macro I think.

Possibly, but very little writing is involved; with but minor amendment,
the procedure is lifted straight from VBA help.


---
Regards,
Norman



"William Benson" wrote in message
...
simplest solution is not a macro, but use Excel's own find function.

1) Enter this formula in the first row in B next to data in A, assuming
starting at Row 2 (example)

=IF(NOT(ISERR(FIND("TOTAL",A2))),"Has Been Found","")


2) Copy / Paste down

3) Copy Col B and use Edit - Paste Special - Values to replace with
values

4) Use auto filter on column B with criteria being < "Has Been Found",
if you want to
group all the rows where that value was not found, to select and
delete the empty string

5) Remove auto filter and you are left with the results you wished.

This is better than writing a macro I think.

wrote in message
...

Dear Prends,

Is there any source code to see my problem below :

If I find particular word (i,e word "TOTAL") from certain cell ("A")
then write to next coulumn ("B") "Has been Found".

I have hundreds like this in cell A

Thanks Forks,

TAHIR


--
mtahir
------------------------------------------------------------------------
mtahir's Profile:
http://www.excelforum.com/member.php...o&userid=25854
View this thread:
http://www.excelforum.com/showthread...hreadid=392395