Create sheet and copy column data from existing sheet, then sort
Posted on 2013-12-24
I have a list of people with various certificate expiry dates (sheet Personnel_Data).
I would like to create a new sheet (Sorted_Data) within the same workbook at the press of a hot-key combo (ctrl-k?).
Rows 1-5 contain header information so the data begins at row 6.
Copy the relevant columns (A (names), G, I, K, M and O (dates).
Column A from Personnel_Data to Column A Soted_Data, G to B, I to C, K to D, M to E, O to F
Then sort data by date columns, to show earliest (closest to today's date) expiry date.
If possible, deleting sheet (Sorted_data) at workbook close.
Hope this makes sense!