Have exisitng excel spreadsheet that requires automation. We use the ssheet for all contact and job info for service calls throughout the year. We schedule the calls at the beginning of the year, add new customer/jobs and pull from the sheet jobs according to date and several other parameters(i.e. part of town, job type, etc.). We would like to automate the data entry on a separat UI page and the same with sorting/filtering for selecting the appropriate jobs.
We would also like the capabilities to batch print the selected jobs onto a custom work order form(already created in Access, but would like to do all of this in excel, I think). We would like to update the ssheet with jobs remaining for the year by importing a report from Qbooks which has the invoiced jobs removed to overwrite the exisiting list.