new book

  1. M

    How to collate data in a single spreadsheet based on 4 criterias

    Hi all, New member here. I have a spreadsheet with the below format. So a single workbook would have 90-100 sheets with that same format. What I want to do is to collate all the data that match 4 criterias in a single workbook: Date, Oversees Manager, Overall Status, Assigned Contractor. For...
  2. S

    trying to run this code through customized ribbon and place it in module

    HI, I'm trying to run the following code from customized ribbon and wants to run this code for all sheets but when i do that it just skips the second case and exits the program. Can you please assist how can i make this to run in module for all sheets. I'm fairly new to VB and i really...
  3. S

    Array data to new CSV file

    Below is my code: I'm trying to store data into an array, once its done trying to open new sheet and paste array data into new sheet's column A. It opens new sheet but doesn't unload data into new sheet. Please assist. Sub LoadArray() Dim TotalRows As Long Dim x As Integer Dim...
  4. M

    VBA to create new workbook + save ... then resume loop

    Hi Everyone - I am trying have a loop in which after each 'loop' copy a particular tab ("Summary") and create its own workbook + save it + then resume the loop in the original file. Is this then possible? This part of the code below I think I need something different because this will just...
  5. melewie

    Create and Name new workbook

    Hello All :) I am having problems trying to write a peice of code that will create a new work book and name it. The problem im having is that the user will likely do this several times, what I would like to do is.... New WB = "Raw Data" if WB Raw Data already exists then new WB = "Raw Data...
  6. E

    Automatically Copy Macro to new Workbook

    I have written a macro which moves selected worksheets to a new workbook and renames it. I need the new workbook to include another macro I have written that sorts data in the worksheets. How do I copy an existing macro to a new workbook within the macro that creates the new workbook?
  7. Y

    Copy and paste drop down Lists into new books

    Excel 2003: I created a form for all my customers, which include a drop-down list (created drop-down list by using validation). I wanted to create an excel document for each individual customer by copying and pasting the 2 sheets into a new book for each customer. When I do that, the drop down...

Watch MrExcel Video

This Week's Hot Topics

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
Top