I've got a data entry sheet on this workbook my agency uses for business purposes.
The data entry sheet consists of names, addresses, personal identifier numbers, and a type label.
Users are currently navigating to this sheet manually, reviewing the content of the sheet for completeness, manually entering new data, then manually sorting the sheet alphabetically on column A's last name values.
The data is duplicated four times so that there are 5 total copies of the same information, per person entered.
I'm familiar with inputboxes but I'm not sure how to go about sorting this sheet alphabetically through VBA.
Guidance is deeply appreciated
The data entry sheet consists of names, addresses, personal identifier numbers, and a type label.
Users are currently navigating to this sheet manually, reviewing the content of the sheet for completeness, manually entering new data, then manually sorting the sheet alphabetically on column A's last name values.
The data is duplicated four times so that there are 5 total copies of the same information, per person entered.
I'm familiar with inputboxes but I'm not sure how to go about sorting this sheet alphabetically through VBA.
Guidance is deeply appreciated