P
philkime
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.
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.