View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default automate copy and paste

I am preparing an ecommerce worksheet with 15,000 part numbers and
descriptions. I am trying to assign a category ID number to each part. The
900 category ID's and descriptions are stored in another worksheet. Is there
a way to automate this procedure? I have been copying and pasting.
thanks,
Richard