Usually data table has tab called "global" that becomes the data source for dtglobalsheet. In my case I have single sheet with one tab named as "global" and other multiple sheet TABS named like client1, client2..... My need is that when I run my script I pass client parameter value as client1,client2....and based on that I should have dtglobalsheet look at respective client# sheet. Is that possible or I do I have to copy the client# to global sheet first.
if client_name=client1 then
datatable.importsheet "D:\clients.xls" ,1,"Global"
elseif client_name=client2 then
datatable.importsheet "D:\clients.xls" ,2,"Global"
<font color="blue">[i]If there is no struggle, there is no progress!