copy and paste rows vba

  1. K

    Pulling rows from multiple sheets and pasting values in appropriate matching headers in a summary sheet.

    Hi there, I am new to VBA and I need help finding a code to extract data from rows in various worksheets with different names, except for the data sheet. The extracted data needs to be pasted and sorted on a summary sheet located at the beginning of the workbook. To give you an idea, I want the...
  2. O

    VBA code to split sales report sheet to groups by invoice type to a new worksheet

    I have a sales master data (with over 20 columns). It contains the following: S/N, Customer, Invoice date, Due date, vessel, producer, fiscal regime, quantity, price, sales value, date paid, amount paid, variance, remark, etc 1.) I need a macro to group this report by invoice type, sum each...
  3. S

    Copy & Paste all from all workbooks in a folder to new worksheet

    Hi there, I need to specify a date and if it matches a date in column A in a different workbook I need to copy the whole row and paste it in a different workbook, and then loop through and copy/paste. Ideally I need to cycle through all workbooks in the same folder and copy paste from each of...
  4. S

    Vba to find multiple specific values and copy and paste them to different locations

    Hello. I am trying to reorganise some data. I have a list of numbers in column A. I want my code to look in column A for all the rows with "350" and copy and paste those rows to U4. I want it to do this for all the different numbers. There is over 100 of them. This is what i have so far but it...
  5. Spotycus

    Only copy rows based on cell value and Paste (values only) into a new table. BankReconciliation Project.

    I have seen this topic a lot recently but have not been able to apply the prior examples correctly for my scenario. I am working on a bank reconciliation tool, and need generating the table of mismatched or unreconciled values. Hopefully the following information will help explain. I have...
  6. F

    problems with copy and pasting the cell

    I have a problem with the code. the purpose of this code is to trace the changes. it does work, but it when I want to copy and paste an entire row. it only copies a single cell. I tried to use an "If else statement" to allow the copy but my skills are focused in Java and php I am new in this...

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