I’m trying to create new excel worksheets for each row in my datatable.
The datatable contains 5 rows with different customer numbers in the first column i.e.:
CusNumber | fname | lName
123 | John | Smith
456 | Jane | Doe
Is there a way to capture the first customer number & create a new excel worksheet called i.e. 123, then the second worksheet name 456, etc all within the same workbook?
I’ve tried a 'for each row in DT > write range however, i just receive an error advising that the range doesn’t exist.