I'm looking to sort data between two sheets.
- sheet 1 has all the data copied in from a massive list
- sheet 2 I would like to have sort columns from the sheet 1 and order them like a custom filter.
For example:
Sheet 1
A1= 30 B1=John Smith C1=08/11/2011
A2= 60 B2=Abby Jones C2=8/20/2011
A3= 90 B3=Joe Good C3= 8/1/2011
Sheet 2
Sort data by column A, then column C, and lastly B
- but have this data populated in a new sheet
- sheet one will have data outside of August, but I'd like to auto sort for that month only.
Does that make sense? It's an employee funnel of opportunities and I'd like to be able to just past in the massive list that gets outputted to me and have another sheet do the sort functions.
- sheet 1 has all the data copied in from a massive list
- sheet 2 I would like to have sort columns from the sheet 1 and order them like a custom filter.
For example:
Sheet 1
A1= 30 B1=John Smith C1=08/11/2011
A2= 60 B2=Abby Jones C2=8/20/2011
A3= 90 B3=Joe Good C3= 8/1/2011
Sheet 2
Sort data by column A, then column C, and lastly B
- but have this data populated in a new sheet
- sheet one will have data outside of August, but I'd like to auto sort for that month only.
Does that make sense? It's an employee funnel of opportunities and I'd like to be able to just past in the massive list that gets outputted to me and have another sheet do the sort functions.
