Copy Paste from excel to excel using loop

[Vikas_Rawat]

Hello Guys, 

I am new to Alteryx, I have created an Input Text data. I want Alteryx to read source file, sheet and range, copy it and paste to target file, sheet and range. help me building it.

Source File	Source Sheet	Range	Target File	Target Sheet	Range
C:\users\altryx\input\Excel File1.xlsx	ANS	G4:G13	C:\users\altryx\input\Output File1.xlsx	ANS	G3:g13
C:\users\altryx\input\Output File_Prior.xlsx	ANS	G4:G13	C:\users\altryx\input\Output File1.xlsx	ANS	I3:I13
C:\users\altryx\input\Excel File1.xlsx	MNH	G4:G13	C:\users\altryx\input\Output File1.xlsx	MNH	G3:g13
C:\users\altryx\input\Output File_Prior.xlsx	MNH	G4:G13	C:\users\altryx\input\Output File1.xlsx	MNH	I3:I13
C:\users\altryx\input\Excel File1.xlsx	Total	G4	C:\users\altryx\input\Output File1.xlsx	MNH	G4
C:\users\altryx\input\Excel File1.xlsx	Total	G5	C:\users\altryx\input\Output File1.xlsx	MNH	G9

[Richard_Data]

All you need is 1 input tool, connected with an output tool. Put that into a control container. Connect it to another control container where you insert another input and output tool. Repeat.

[binuacs · Accepted solution]

@Vikas_Rawat one way of doing this with a batch macro

[Richard_Data]

Thank you! I will be using this myself

[Vikas_Rawat]

C:\users\altryx\input\Excel File1.xlsx	Total	G4	C:\users\altryx\input\Output File1.xlsx	MNH	G4
C:\users\altryx\input\Excel File1.xlsx	Total	G5	C:\users\altryx\input\Output File1.xlsx	MNH	G9

@binuacs for some reason this is not working. Macro is ignoring these fields

[Vikas_Rawat]

Please ignore.. I found the solution