copy & paste sheet 2

  1. S

    Copy data to new Sheet

    Hello All, One of my vendors that sell Tree's & Plants sent me a price list which is about 10,000 lines long. I use this for quoting. What I would like to do is have a QTY column. I search for the item and enter in a number in the QTY, then I would like to copy this entire line to Sheet B...
  2. J

    Count IF Cell text and in sheet 1 and insert counted rows in sheet 2 below the specific cell text Macro HELP

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I have 2 sheets, QuantitySOLD & QuantityAvailable QuantitySOLD is about quantity of rice or wheat or tomato sold date wise QuantityAvailable is the quantity of items available...
  3. T

    Move and delete the active row in VBA

    Good Day, I am working on a automated handover code to send an mail and all is working perfectly. I would like to move the active cell to the next sheet after the last row there and then delete the blank row as well. I have tried different examples from the web but with no luck Sub...
    • Tiny_t
    • Thread
    • copy & paste sheet 2 delete blank vba & excel 2013
    • Replies: 3
    • Forum: Excel Questions
  4. B

    Archive Row based on Input of cell

    Hello, Im wanting to take the entire row of data logged and move it to another sheet called "SR_Archive" after the word "Yes" is selected in the cell. I have 32 rows that span down from A3 to S3, I would like this to be a running archive so each time i select "Yes" it moves the data to the next...

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