new workbook

Good Afternoon is it possible to automatically create tabs from text in a xls book and populate the new tab with data split by comma using the colors column? From this master sheet containing data, I need to create unique tabs based on color. I'm thinking of pressing a button and a...

Hello, I'm new to vba, i saw a post when i was researching to: how to copy all the details from one sheet, copy this and save it in csv format on a specific folder. Then luckily I saw the code @Georgiboy posted and tested it: Sub Print_Test() Dim FSO As Object Dim TextFile As Object Dim rCell...

I have this extremely strange issue with one of my VBA script JSON codes where it only runs fast (about 1 min and 20 seconds) when I open up a new workbook and insert my code and add Microsoft script reference right there. However, besides this it takes forever to run. Also if I save this file...

Good Day to you all. I am having an issue with the code below. I have spent hours trying to get it to run correctly but being a bit of a novice at coding I've hit a brick wall now. I would really appreciate your help. The problem is if I run the code, then when asked I choose 'Yes' on the...

Hello all, I have created the VBA code to copy an Excel sheet to a new workbook in .xlsx format as I need the new workbook to be free of macros. However, the sheet I'm copying has the company's logo and I need it to be on the new workbook as well. However, is not doing it. The code I'm using to...

Hi All, So to give some background, i have a large data set (60k plus rows and 90 plus columns) that i need to filter and create a new workbook using specific columns. The size of the file changes daily, and columns are taken out and added. So i had to keep updating the previous macro i had...

Hello, I've been working on a complicated workbook but have ran into a problem that I can't seem to solve. I need to output a list of invoices to an external application (it can be imported as an .xls file but must be in a stand alone workbook on Sheet 1 for this to work). I have so far managed...

Hello i need a macro that will Save the current active sheet as a workbook Any help would be greatly appreciated Requirements: Save active sheet as a workbook Values only Save to specific location E.G. "C:\Users\Username\Desktop" Save the file name as "text" & " " Active sheet name

Hey guys so im struggling with making a macro: To start; i get inventory lists that don't have my data on it and have to go copy columns from multiple tabs. I was creating the macro below but the problem am having is: How can i make this work on any 2 workbooks i have (ex: this one is copying...

Hello, I created a macro that uses a counter to create 3 worksheets for each country included in a data tab. The data tab can have a variable number of countries, so the macro counts the number of countries and creates a Cover Sheet, Expense Sheet, and Income Sheet for each country (e.g. the...

Hello everyone, I'm going to complete my simple application relating to creating new workbook, copying data sets from the workbook where I run my macro, pasting the set to the new one with possibility to point out a path. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As...

I am in the process of automating some of my workflow and cannot figure out how to best approach this situation. I have an inventory sheet that I would like to create new sheets off of based on categories. Each category would need its own file generated along with all items included...

hello i have a workbook titled 3 months and in this wb i have Sheet1 which contains data i need copying to a new wb if cell in column D is 0.1 or less, this could be 1 or 200 rows. this new wb would need to be saved in a different filepath. i'm assuming this is possible but i am not sure how...

Hi, I've seen some similar posts, but most have been too specific for my needs. I have a workbook with 150+ worksheets, containing reports for 60+ employees. All have at least two worksheets; many have three or four. I need to be able to group the two, three, or four worksheets for each...

I need to be able to have individual sheets from different WKBKS to link data to another WKBK which is my dashboard. What I am trying to achieve is I need is to be able to open all WKBK'S in a Folder automatically and import the data, sheet1 from each WKBK so that the sheets copied will...

Hello, can anyone please provide guidance on how to edit the following code to *delete* the worksheets beginning with "Labor BOE" from my initial/primary excel worksheet, after these sheets are copied into a new workbook? Here is the code being utilized: Sub Export_X() Dim Sh As...

Hello, I am using the following code (which works great) to export the sheets named "Labor BOE xxxx" after my spreadsheet creates multiple copies of a template worksheet, inserts summary tables, and populates the summary tables. The one issue that I haven't been able to figure out is... after...

Hello, I am using the following code to copy multiple worksheets into a new workbook. Unfortunately, the worksheets aren't copying over. I am wondering if creating the new workbook is changing my "Activeworkbook" which is referenced on line 6. Any thoughts on how to correct this? Also, I...

Hello, I am attempting to do the following: Copy all worksheets whose name ends in "-PP" into a new workbook (formats, values - NO formulas) Open a pop-up box in the new workbook that asks the user to enter the version number Open the save as window and save the file to the user's desktop as...

I am trying to accomplish something that I would suspect is a common type of problem, but I have been all over the internet and I'm having trouble finding it: I have a master excel workbook with lots of macros, formulas, and data from many sources which I copy each week to do my planning. I...