Move data to new sheet depending on criteria

[enna49]

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

[Ron de Bruin]

Hi enna49

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


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



"enna49" <[email protected]> wrote in message news:[email protected]...
> 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