27-04-22 01:23 PM
Answered! Go to Answer.
27-04-22 09:27 PM
Hi @Felipe Gaia,
Are you using single handle or multiple handles?
I would prefer using single handle even for handling multiple excel files. Please use the below set of activities to achieve the functionality:
1) Use Select action to select the range which needs to be copied from 1st excel.
2) Use Copy action to copy the range
3) Use Activate worksheet to activate the destination worksheet
4) Use Go to Cell to go to the destination cell where pasting needs to be done
5) Use Paste action to finally paste the data.
It should work. Please let me know if it doesn't work.
27-04-22 03:15 PM
27-04-22 03:39 PM
27-04-22 09:27 PM
Hi @Felipe Gaia,
Are you using single handle or multiple handles?
I would prefer using single handle even for handling multiple excel files. Please use the below set of activities to achieve the functionality:
1) Use Select action to select the range which needs to be copied from 1st excel.
2) Use Copy action to copy the range
3) Use Activate worksheet to activate the destination worksheet
4) Use Go to Cell to go to the destination cell where pasting needs to be done
5) Use Paste action to finally paste the data.
It should work. Please let me know if it doesn't work.
27-04-22 11:44 PM
27-05-22 03:32 AM
27-05-22 03:39 AM