copy to another workbook

  1. A

    Loop through master sales sheet and copy data to different workbook and worksheets

    Hi Guys, I have a sales workbook that has a new worksheet added every week with latest product sales. I also have a total sales workbook that has a different named tab for every product name. At the moment I have a macro that is run on the Master sales workbook and with the aid of a pop up box...
  2. W

    If statement for entire column

    Does anyone know how I can put my IF's so I wont what to put this formula in 300 times. I have it setup where individually every IF statement will paste to the next row on another workbook. I want to repeat this process but with SubmissionID = A4:A300, BatchName = B4:B300, etc. so that I don't...
  3. E

    Declaring a Workbook as a Variable

    Hi, I have the following code. It worked previously, but for some reason, it won't work now! I get an error when I try to Set TRF below... s = "Nov Trend Report.xlsx" v = Left(s, Len(s) - 5) Windows("Trend Report Model.xlsm").Activate Dim TRF As Workbook Set TRF = Workbooks(v) I have 2...
  4. A

    Compare 2 columns from different workbooks and copy non-matched data to another

    hello! I have 2 worksbooks and i need to compare one column from workbook1 with another column from workbook2 and then I need to put the non-matched data into workbook3. Is it difficult to do in a macro? i dont have an idea to do that :( thanks for your help...
  5. A

    Can I copy data tables (and connections?) to other workbooks?

    I have a workbook (wkbk1) that has a sheet with eight different tables on it. They all point to the same external Excel workbook (wkbk2) for their data. The data for each table comes from a named range. How can I copy the sheet of eight different tables (from wkbk1) to other workbooks (wkbk3...
  6. J

    Get last cell value and copy to another workbook??

    Hello to all, I am new to this board. I need help with the following. I have 2 workbooks, WB1 and WB2. In WB1 I have two sheets, S1 and S2. S1 has a list of invoices with customer information. In colunm A is the invoice numbers in sequential order from 1001. S2 is the invoice I fill out. How do...
  7. V

    Copying to another workbook error

    I am at a complete loss as to why this code does not work. It gives the 'run time error 9 error'. The other workbook exists and is open after the first block of code. Any help greatly appreciated. Thanks. ' create a new workbook Dim newWorkbook As Workbook Set newWorkbook =...

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