move range

  1. M

    VBA to Find subtotals = to 0 and move associated rows to new WS

    Other than subtotaling NETAMT at change in Asset Nbr, how can I group by Asset No, and if NetAmt of group equals Zero, then move range to another WorkSheet. Example of WS is shown below. :confused: Thank you!
  2. R

    Copy Range of Active row to next sheet

    Hello, I would like the vba code to move the range columns A thru I of the row of the active cell(but not the whole row) on Sheet1 to Sheet SOLD on the next available row within rows 1thru 80 (same columns) and then delete the row of the active cell on sheet 1. On SOLD sheet there are column...

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top