How to extract data from One excel sheet to another excel sheet

Help Activities
, ,
1

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?

2

HI @Shrirang_Zavar

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

3

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:

image

Output:

image

Hope this helps,
Best Regards.