Filter data into separate worksheet

[yolanda.silva]

I'm in the process of trying to make a spreadsheet for work but I'm
just clueless... excel is not my area of expertise!

The original spreadsheet has 10 columns with various pieces of
information... column D is what is important to me... column D has 5
choices for "reasons"... I want the main tab to remain untouched but
in the other 5 tabs of the spreadsheet, I want the different "choices"
to then filter into the other tabs...

For example - the choices include "Coverage" "Equipment" "Customer
Service", etc... I want the tab entitled "Customer Service" to have
all the rows retrieved that have "customer service" as the entry for
column D... the only issue is - I want it done automatically... not a
filter I manually do because I will get data everyday to add to the
main page and I want it to just dump into the other tabs.

Is that possible? Can someone help me?

Thanks!

 

[Ron de Bruin]

See
http://www.rondebruin.nl/copy5.htm

Or use this Add-in if you not like code
http://www.rondebruin.nl/easyfilter.htm