I am currently working on a big datatable of Orders, I want to get the order # and then using a switch, put it into an excel spread sheet for a corresponding agent.
For each row in Orders Datatable
Switch statement for the order #
Matches and then will insert the current data table row into the corresponding agent’s excel sheet.
I am looking at “Append Range” but am unsure how to just add the current row from the “for each” loop instead of the entire Orders Datatable.