Filter data into separate worksheet

  • Thread starter Thread starter yolanda.silva
  • Start date Start date
Y

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! :)
 
Back
Top