paste rows

  1. E

    copy and paste rows in excel to another worksheet vba using input box for the amount of rows to copy

    Hi, I'm new to VBA and have been trying to find a code that will transfer data from sheet 1 to sheet 2 using an input box on the amount of rows to copy over. Sheet 1 is where the user will input the invoice information from D6 to P6, once the information has been checked it would then be copied...
  2. D

    copy a row if cell contains data

    I am having a hard time finding a good solution for this. I need to simply copy an entire row and paste it to the end of a row of another sheet. logic: if cell contains date between today()-120 then copy entire row and paste row at the bottom of another sheet. lol I hope that makes...
  3. B

    VBA Count Non Blank Rows On Sheet 1 and Copy Paste Based on Counted Rows in Sheet 2

    The following VBA code to count rows but it only counted one row out of 10 rows. The count starts at row 4 and cells in column A contain formula. How to modify the code to be able to count the non blank cell. Did try to replace Count with CountA but it does not work...

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