1. are your data numbers or text?
2. are there duplicates in your data?
--
Gary''s Student - gsnu200855


"philkime" wrote:

I have two sheets.
Sheet 1 has columns A,B,C,D,E.
Sheet 2 needs to have copies of Sheet 1's columns A,B,D,E
Sheet 2 should be sorted by column E (all of the columns sorted on E,
like an extended range sort)
Sheet 2 should auto-update as Sheet 1 is changed

Now, I know I can do this in VBA but I can't use VBA (has to work on
Mac Excel 2008 too). It needs to be done in XLM and/or standard macros
only. Can't be manual at all (no clicking buttons, no manual sorting).

Any ideas? Such a simple task but seems quite hard without VBA.