I have a task where I want to export to excel sheets based on the worker role. There are 2 columns, Col A is the permission task, like access to client records; and col b is either
'has access' or 'no access'. We have over 20 worker roles and each would get it's own sheet in an excel.
I wanted to know if when doing the excel export it can direct rows to a particular sheet in the file.