How to filter certain records on a new sheet

[marcvanderpeet12]

Dear all,


I working on a sheet in which i would like to seperate certain records from one page on the next tabs in the file.


On the main page I have an overview of agents; brokers and other customers with their adresses and I would like to create an overview in the next tabs with one page with agents and their adresses; one with brokers and their adresses etc... So i need a fuction which basically screens through all the records on the first tan and then copies the record to for examples the broker tab (when it's a broker obviously).


Anybody some suggestions on this?


Thanks in advance!


Marc

 

[Hui]

Marc


Firstly, Welcome to the Chandoo.org forums.


It might be worth reading this post as I think it will do what you want:

http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/

 

[marcvanderpeet12]

Thanks Hui!

 

[marcvanderpeet12]

Hui, it worked out really well for a while. But now it only updates on of all the records... So I got different Brokers which have to be transfered to another sheet but it only takes the last one. You know what might be the problem??

 

[Montrey]

Marc Take a look at Advanced Filter.


http://www.dailydoseofexcel.com/archives/2012/07/07/excel-advanced-filter/


It does everything you want and more! :D

 

[marcvanderpeet12]

Thanks!