View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Move data to new sheet depending on criteria

Hi enna49

Try this
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"enna49" wrote in message ...
Hi
Hopefully this can be done.

I want to create a button on a sheet that will import all data from a master
sheet. eg if CostCode = 11005, I want all that data that refers to this
code to be moved to a sheet marked for that code beginning on line 2 of new
sheet.

Thanks enna49