Hi,
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
Regards
Sudharsan
Hi @Shrirang_Zavar, welcome to the Community.
As per your requirement, the following workflow is designed in order to take the From-To sheet names from a master file. Please find the same:
DynamicColumnName.zip (31.5 KB)
Input:
Output:
Hope this helps,
Best Regards.