vba copy data

  1. D

    Copy values multiple columns (non-adjacent) to another sheet

    I have a workbook with 2 sheets that are identical, except one of them has a data connection that can be refreshed. I want to be refresh the data and then run this code to automatically copy those columns (as values) to the other sheet. I tried to combine into a single operation, but it wouldn't...
  2. C

    VBA to open 2 workbooks(name changes on 1), copy and paste data and drag down existing formula

    Hi, Thank you in advance. This one is a bit long. Sorry! So I download a file daily and I use that to replace the data on another file which is 1 of my database excels for my main template. The VBA that I'd need would be the following: * Open both Excels(I'm guessing they have to be opened for...
  3. C

    Copy data automatically from multiple sheets

    Hello. Glad to find this forum!!! I have about 38 users each with one excel workbook that contains the 3 sheets. I would like to create a MASTER Workbook where I can have the 3 tabs and that can automatically update the information inserted in each workbook. for example if one of the tabs is...
  4. D

    VBA - Master Copy File not all columns will copy

    I'm trying to create a macro that will take a daily pre-designed format sheet (people just input the numbers in to rows, and columns) and insert them into a combined yearly master. It will copy all the rows just fine it seems at the moment, but it stops at column CD and I need it to go to CQ...
  5. P

    Copy from multiple workbooks into one new workbook

    I found a great code for copying worksheets from multiple workbooks (up to 2000 workbooks) into one new workbook. Thanks Dan Wagner for writing it. It works perfectly for 99% of the copying/merging that i do. The only issue with the code is that it only copies from the active sheet in the...
  6. A

    Vba code to copy data from one sheet to other sheet

    I want to copy Range (A9:L9) in "Email Data" sheet in Demo workbook and paste in last row (i.e. B773 to M773 and date in A773 - here the date will increment from last row date) in "Data" sheet in Devices workbook and change both the graph in "Graph" sheet to contain last 20 days data in each...

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