Need Excel template to sort data automatically between worksheets. RRS feed

  • Question

  • How do I set up Excel to automatically divide data between multiple sheets.  Basically, data will be dumped into Sheet 1.  I need to set up an excel template so that if for example: Sheet 1 contains 10 accounts where 2 contain "Apple", 2 contain "Banana", 2 contain "Cherry", 2 contain "Donut", and 2 contain "Egg".  Once the data is dropped into the template into Sheet 1, I need the "Apple" accounts to be sorted into sheet 2, "Banana" into sheet 3, "Cherry" into sheet 4, etc.  I need to template to be reuseable daily with a new set of data.  I hope this makes sense.
    Tuesday, April 6, 2010 10:16 PM