data transfer across sheets of datatable

[ajay.r1982]

hi,
i have 10 rows of data in global sheet of datatable.
i want to transfer all the data to the local sheet.
how can i do it ?


cheers,
AJ

[desimunda]

Code:

Dim rCount

rCount = datatable.GetSheet("Global").GetRowCount

For i = 1 to rCount

DataTable.SetCurrentRow(i)
DataTable.Value("ColumnA", "Action1") = DataTable.Value("ColumnA", "Global")
DataTable.Value("ColumnB", "Action1") = DataTable.Value("ColumnA", "Global")
DataTable.Value("ColumnC", "Action1") = DataTable.Value("ColumnA", "Global")

Next

That should work!