Tab to tab movement between two Wdesk files using chains
AnsweredHi Team,
I have a requirement to move/copy data from tab1 of Spread sheet1 to tab2 of spread sheet2 using chains, noting down spread sheet1 & 2 have around 200 tabs each. Kindly suggest the suitable way and command for this.
Thanks,
Madhuri Desai.
0
-
Hi Madhuri, you can get generate a list of Sheets from Spreadsheet1 with List Sheets, iterate over the list to get the data from each Sheet with Get Sheet Data, create a new Sheet in Spreadsheet2 with Create Sheet, finally write the data to the new Sheet with Write Sheet Data.
0Please sign in to leave a comment.
Comments
1 comment