Currentlly i using microsoft office excel 2000 to do ducument check with certain numbers.First press Ctrl + F --> enter the number that i want to search,example(HV3000H) thn press "enter". If found it would highlight that number(HV3000H) and i can do the editing on that number or colour changing. Then press "Esc" and follow the same step for others sheets checking. If the number not found, it would prompt up a message "cant found the data". Then press "Esc" and follow the same step for others sheets checking. Any others faster or easier ways or visual Basic language can help to minimize this checking task cause this is my job scope everdays.
i knows about excel and Visual basic.
Can anyone give me advise??
