Simplify way of delete, copy and paste the multiple range data in excel

Help Studio
, ,
1

Hi,

I am beginner in UiPath. Now learning the basic feature & trying to perform the delete, copy and paste for my month tasks.

I wanted to delete, then copy & paste for the highlighted range, these range of data is same for workshop A, B, C, D.

image
image873×673 29.7 KB

Currently I am using the delete range method, but the list is getting longer.

May I know is there any simplify way of delete, copy and paste the multiple range data in excel for the above scenarios?

Thanks.

2

can you give more information about what you wanna do?

3

Hi, I wanted to create a project just to delete the data in workbook A, then copy the data from workbook B, and paste those data into workbook A.

First, to delete those data (highlighted in yellow range) in the workbook A: there are 4 worksheets (workshop A,B,C & D), the data to be delete are in the same range for all worksheets.

Second, to copy the data from another workbook, there are few section:

  1. sales
  2. Direct Cost
  3. Indirect cost
  4. Selling expenses
  5. Admin expense

Final step is to paste all the data back to workbook A into all the yellow range.

Thanks.