Apr 22 2020 09:10 AM
In an Excel file named CONNECTIONS.CSV, there are the following Column Names:
First Name | Last Name | Email Address | Company | Position | Connected On |
|
|
|
|
|
|
As of right now there are more than 8,400 rows of data in these columns and they are all at the column width of 8.43. The contents of the file will continue to grow.
I wish to create a macro that will sort them by last name and auto-fit the column width. Assign Shift-Ctrl-N to execute the macro.
I had a macro that did exactly that and I must have blown it away when I “organized” my PERSONAL files.
Can anyone assist? If so, you have my undying gratitude.