create new workbook

  1. C

    VBA looping with defined name as criteria - rows

    Hello, I'm writing some protocol that prints out reports based on a list that I put into a defined name. So there are 14 locations that I want to run the report for that I used the defined name "Locations". I have a data dump worksheet that contains a list of users and there information. I want...
  2. D

    Print Preview (2000 vs 2013)

    I am creating a new Workbook using VBA from another Excel Workbook. I then want to perform a PrintPreviewof the new Workbook. However, the whole thing hangs. I believe this is because the PrintPreview is executed before Excel has completed creating the new Workbook. I have looked and looked and...
  3. K

    Create a new workbook and copy the filtered data to the workbook created .

    Hi All, I have a data sheet with various project Managers names nearly 100 project managers.I want to write a VBA code to filter the data for each project manager and create a new workbook and copy the related data of the project manager to the created work book.And please make a note that the...
  4. G

    VBA Macro for adding files in same folder and copying tabular columns

    Hello, I need your help. I am trying hard to do this. I have a work book in which the sheet - "Master list". Column D contains the master list of clients. 2nd sheet "Template" contains the master tabular column. In the same FOLDER, I have a file created for each existing clients. I will...
  5. P

    Macro to create new workbooks based on cell values

    Hi everyone! Hope you can help me with this as I found a code to create new workbooks but I cant's seem to bring it together. I have a workbook to create folders based on some data I paste into a group of rows. For each row it creates a folder. I got this to work quite well but now I also want...

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