#copyandpaste

  1. G

    Copy specific columns from multiple sheets to another sheet

    Hey Guys, I have multiple sheets with the same headers (Column A to Column K) and dynamic rows. The data in each sheet is already sorted. I want to copy data from only Column A, B, J, K from each sheet till last row where value of J is greater than 10 and paste to single destination sheet from...
  2. J

    Copy data from workbooks in a folder to one master workbook

    Hi. I have data in multiple workbooks in a folder with the same template and I need to extract those circled data into one master workbook as below I have a code to loop thru all the workbooks in the folder but I do not know how to do the data copying/extracting. Thank you for any help!. Sub...
    • jayn309
    • Thread
    • #copyandpaste #excel #expert #vba #vba #copypaste
    • Replies: 25
    • Forum: Excel Questions
  3. J

    How do I reference range of columns for my copy/paste VBA code?

    Hi All, I've been busy creating a code that, depending on whether the values in a column are greater/less than 0, the code will copy those values to the bottom of the table and paste them into a corresponding table. The problem Im having is that Ive had to repeat this code for each column and...

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