ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Move data to new sheet depending on criteria (https://www.excelbanter.com/excel-programming/369687-move-data-new-sheet-depending-criteria.html)

enna49

Move data to new sheet depending on criteria
 
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

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





All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com