Hi there
I need some advice on copying. The scenario s like this. based on an
inputbox string, the code looks for the similar value from the sheet
called 'main data'. if found, copy the entire row into a new sheet
called 'search result'.
The code works perfectly well. Then i added in other bits of code to
check if the search result worksheet exists and if not create new one
etc. It went fine too for about 2-3 times. Then I saved the workbook
and run the macro again. Now the copy doesn't work anymore.
For your info, i m using Office excel 2003 prof. ed

p.s: this is my first time posting. sorry if i missed out anything.
thanks a lot!