new book

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...

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...

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...

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...

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...

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?

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...