View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kingie kingie is offline
external usenet poster
 
Posts: 11
Default Find Cut and paste

Hi,
I have a large amount of data containing unique codes.
I want to type in a list of codes and the program to find them in worksheet
1 Cut and paste it into worksheet 2.
I can set up a macro to do the cut and paste but its long winded entering
each code into the find box then waiting while the code is found then cut and
paste using a macro. Any ideas on how i can speed it up please?