Data sorting with marcos
I am pretty new to Visual Basic, and am trying to create a spreadsheet to use at work for dispatching employees.
It is for my dispatcher to use, who needs the sheet to be as simple as possible to use.
Basically what I am looking to make is one sheet that lists employees names, with a column for work location, and a column for equipment they will be running. I would like the employees to be listed alphabetically for this chart, and also for my dispatcher to have the ability to add employees when we hire.
The final sheet I need is a sheet that is organized by work location, with employee name, equipment, and job number.
I have been using the record macro function, but I keep running into problems when I try to use the Data Filter. I get a message that says "..with block"
Any suggestions would be greatly appreciated!