# Copy data from 1sheet to other sheet as per selected option

#### jangir72

##### New Member
Hi,
I have large date in sheet "CB" from Col A to Col AB
I want to copy them in sheet "Report" as per following options:
If Option selected:
Fill col. A to K from Row 4 of in "Report" with Columns shown below from Row 9 to empty row of "CB" :
(1st row in below table is Colums of "Report" and other rows are columns of "CB" )
 A B C D E F G H I J K L Option 1 A N D B C E F G J K L FORMULA Option 2 A R D B C E F G J O P FORMULA Option 3 A V D B C E F G J S T FORMULA Option 4 A D B C E F G W X FORMULA Option 5 A D B C E F G Z AA FORMULA

<tbody>
</tbody>

<tbody>
</tbody>

Then delete row if Col J + Col K = 0 in case of Option 1 to 3 and if Col H + Col I = 0 in case of Option 4 to 5

Sort Col B wise
Fill formula for running total (e.g. for Option 1 to 3 in cell L6 = L5+J6-K6; for option 4 and 5 cell J6 = J5+H6-I6

Fill column header in row 3 of "Report" from Row 8 of "CB"

Could somebody help me to solve it though Excel VBA.
Warm regards

Last edited:

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Replies
5
Views
197
Replies
9
Views
126
Replies
3
Views
190
Replies
5
Views
590
Replies
4
Views
166

1,195,628
Messages
6,010,772
Members
441,568
Latest member
abbyabby

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back