copy rows using vba

  1. C

    Pull specific row data based off column information

    Hello folks. Am currently working with a Main dump of data that contains about 200+ columns and several thousand rows. I have to manually filter/sort/cut/paste things to get clean data and am looking for a VBA solution to help ease some pain here. I have been searching and experimenting for...
  2. S

    Selective Copy Data from Sheet A to Sheet B without Blank Lines

    I would like to take Data from the "ALL REPS" Sheet and selective Copy out Data from it to another Sheet. I have the Below code that seems to work, though it has some issue. When it gets to line 10 in 'ARC 5A' it just copies over the same row over and over. If I remove the Clear Content code...
  3. N

    If cell = X Then copy row to Worksheet named X. If cell = Y Then copy row to worksheet named Y. If cell = X and Z Then copy row to worksheet named XZ

    I have a spreadsheet with multiple headers and i need a VBA code that can search the first worksheet, named "Merged" for various words. So if the word "Nathan" is found that row is copied to a worksheet named "Nathan" and if the word "Tom" is found that row is copied to a worksheet named "Tom"...
  4. B

    Code to copy a row to another sheet using dates

    I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In column H I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to copy the work orders that are completed in...

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