I want to extract data from multiple sheets i.e sheet1,sheet2,sheet3,sheet4 to different another excel sheet i.e A, B, C, D and the sheet1 data should be added in sheet A, same for sheet2 data should be added in sheet B, and same for sheet 3 data added in sheet C, sheet 4 data should be added in sheet D.
I need some ideas?
Welcome to Community!
Try this way
Just Use Copy file activity and copy the main file and save them to the appropriate location and rename the file in the copy file activity and then Rename all the sheets to name you needed