automatic copy paste

  1. N

    Copy and Paste Data From one Workbook to Another Based on Criteria

    Hello, I have two workbooks: 1) called "Source" and 2) "Trend". I want to put a command button in Trend that copies data from Source and pastes it into Trend. The workbook Source is always open on a computer downstairs. Users record data on it throughout the day. The workbook Trend is on my...
  2. N

    Auto Copy Data from Excel Workbook Based on Criteria using VBA

    Hi All, I want to automatically copy data from an old Excel Workbook into a new workbook based on criteria using VBA. I already found a good example of this here: Copy Data to Another Excel WorkBook Based on Criteria Using VBA | Excel VBA Training Videos However, this example puts the VBA...
  3. D

    Automatically Format Copied Cells

    Hi! I love this place! I'm running Excel 2007. I will be copying (or cutting) and pasting a row of cells into another worksheet that has accumulated over time. I'd like the cells I'm copying/cutting to automatically "adopt" the formatting of the cells already present. Basically, the cells in...
  4. D

    Conditional automatic copying

    Hey all, I need help from you "more experienced guys". My idea is pretty basic, but since I am still rookie I just can´t write it. In my work I do a lot of copying and this would help a lot. In my excel file I have in one column "Material" codes of products with following weeks(variable...
  5. C

    Macro button to copy data from other worksheets in the workbook to summary sheet

    Hi, I am trying to create a macro that will extract data from all the worksheets in a workbook to a summary sheet (which occupies Sheet1). In a nutshell, I have several worksheets in a file that I adjust individually from time to time, they all maintain the same exact format with same...
  6. J

    Copying data from one spreadsheet to another after data input

    Hi All, I recently posted a question regarding copying of data from one spreadsheet to another but the spreadsheets I were using were causing problems with their complexity. I have now amended the spreadsheets to try and make the process a little easier. I have one spreadsheet for Site...
  7. C

    Automatic Copy / Paste Macro Needed

    Tomorrow I have a project that will require a few hundred copy and paste operations. It will go a lot quicker if I can find a macro that would allow me to copy the contents of a cell on one click and paste into a different cell on a second click. In other words Click #1 selects the cell 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