Tab to tab movement between two Wdesk files using chainsAnswered
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.
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.0
Please sign in to leave a comment.