copy to another worksheet

  1. M

    Moving Entire Row based on Cell marked "Completed"

    I am new to this and trying to get each row to automatically get copied to my second sheet "Completed", then deleted off my main sheet... So - when I select "completed" from the dropdown in Column "N", that entire corresponding row essentially moves over to the second sheet labeled "Completed"...
    • MoonPrincess
    • Thread
    • code & formula copy to another worksheet moving data vba & conditional formatting & protected worksheet vba calculations
    • Replies: 3
    • Forum: Excel Questions
  2. B

    Error message in assigning array values in Excel rows to another sheet

    I get an error 1004: Method 'Range' of object'_Worksheet' failed. I have an Excel worksheet called "Open Items" and another called 'Closed Items' in an account reconciliation workbook. My code is successfully identifying consecutive-row matchups of WBS Element numbers (SAP) and amounts...
  3. J

    Copy a block of data to another worksheet

    I have a workbook for scheduling purposes. On sheet1 ("Staff") I compile availability. I'd like the macro to sort the data according to column H (availability), select and copy the block of data at the top (anything that has a value in column H), then transfer this info to another sheet...
  4. J

    Copy rows from one Master work sheet to multiple worksheets

    We have a spreadsheet of all our client's trademarks and relevant information. All the information is contained in a worksheet titled "All." I would like the information contained in the rows from "All" to be copied to the applicable worksheet based on values in "All" column "E" and column "I."...
    • JJgold
    • Thread
    • conditional formula copy multiple ranges copy to another worksheet macro
    • Replies: 8
    • Forum: Excel Questions
  5. A

    How do I automatically copy multiple column ranges to another worksheet based on a specific reference?

    I have a workbook I'm working on that has multiple worksheet in it. There are 2 worksheet specifically that I need assistance with. The "Renewals" worksheet and the "Scheduled" worksheet. I have attached a copy of the workbook in question to make it easier to understand. My goal is, if I enter...

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
Back
Top