new sheet

Hi All, I really hope some genius can help me. Excel in Office 365. I have a spreadsheet that contains an array of data (column A-Q and row 2-10,000) The data that I have is generated from 34 sheets within the spreadsheet (I have converted each sheet into a table) and have been collated all...

Hi there! I am attempting to manipulate data from a very large sheet that I will be udating on an ongoing basis. I would like to find VBA Code to automatically copy rows from the master sheet to a new sheet, based on the values shown in a given column. I have several comumns of data and, in...

Hello I have this code below that copies the entire sheet, renames the new one with the current date and erases the contents of certain range that works perfectly if I just run the macro. Now i would like that to work with the Workbook_NewSheet function in the workbook section of vba but all it...

Hello Geniuses! I have a code that refreshes my pivot table of names, copies a blank template, adds a new tab based on the values in that pivot table, and names each new tab the unique name from the pivot table. My issue is that since I am using a pivot table, it is pulling that columns header...

Hello all, Can decipher this impenetrable code sufficiently to make it ignore the first row on the sheet on which it runs? I am changing the sheet so that the control buttons take up row one. This sub is called from a larger sub that also changes the button settings so that they are...

Good day everyone. I have a challenging question on VBA. I have a table that contains approximately 3000 rows of customers (customer name in column F) that are allocated to about 20 different location codes in the US (location code is column B) Each week I need to move a predefined number of...

Alright folks, I am having an issue with copying and pasting into the next blank cell onto a new sheet. I currently have a macro in excel that adds a new row at the bottom of a data set and then sets the current date into the cell A1 of that new row and the rest of the cells are blank. What I...

I am in need of a VBA to copy range E2:O100 and R2:AJ100 and place them on a new worksheet starting at the third row Column E thanks in advance for any and all help

I have a sheet of 324 columns and 72 rows. I want to copy specific columns from sheet and paste them side by side in following manner 1,12,24,36,48.....(multiple of 12..... upto 324) side by side in new sheet1. then 2, 13, 25, 37,49(multiple of 12+1)...upto 324 side by side in new sheet2. then...

Hi, I am relatively new to Excel VBA and I am trying to create a personal template for my work. I already have the below code to insert a new sheet. But I don't know how to change the tab color based on a fixed cell value. Sub GenerateConf() On Error GoTo MyError Sheets.Add...

Hello, I am wondering if it possible (and if so, how) to keep formatting when creating a new worksheet in excel, similar to a template. For example, I have a sheet with a photo, text, and column headers that I want to keep on all worksheets within this workbook. Ideally, I would like to click...

Hey Friends! I am trying to figure out a way to create a named worksheet from clicking a value in a Pivot Table. The default of excel, of course, is to create sheets with your detail you're requesting titled "Sheet1" and "Sheet2" etc... I would instead like it to name the sheet to whatever it...

I am working on an inventory spreadsheet and have multiple things that i have working. but the one thing i seem to be struggling with is that i have a sheet "RECORDS" which keeps track of how many of each item i have for the date the inventory is checked which is every other week). what i am...

I am working on an inventory spreadsheet and have multiple things that i have working. but the one thing i seem to be struggling with is that i have a sheet "RECORDS" which keeps track of how many of each item i have for the date the inventory is checked which is every other week). what i am...

Hello Everyone! I am trying to create an automated report and new to VBA. I would like to use the split function in order to split column (text) to several columns (according to delimiter) into a new sheet. For example (same workbook) Source sheet: Extraction column C (cell C2) H04N21/413 |...

Hi. I'm hoping for help with a code in Excel that will copy and automatically name the new sheet as 'active sheet' + 1. For example, if I am on a sheet titled "3", I would like for the new sheet to be titled "4" Thanks to MyExcel.com, I have obtained code that creates a desired quantity...

Hi. I need to create a large amount of sheets in Excel. Please help me by posting a macro that can do this. I would like to be able to type the quantity of sheets, and I would like for them to be automatically named in ascending order: "1", "2", "3", "4" etc. I would really appreciate any...

After browsing the web, I've managed to find a macro to help me with the above task. Only problem is that it copies over the formula as well. I'm having difficulty in finding away for it to copy and paste special values. Can anyone suggest a tweak in the below code? Sub CreateOrder() Dim cell...

Hi All, Hoping you can help. I've got a workbook which keeps breaking. It consists of quite a few coloums and about 20,000 rows. I'm trying to make it so when there is a value of "Yes" in range X on sheet "Flightlist" it cuts the entire row that the "Yes" value is on and pastes it another...

Hi guys, I have created following code, the code looks for a certain value of a colorINDEX=23 I got a Msgbox that tells me the correct value of a certain cell, then I recieve the first cell in the column, now I need a loop through all columns in each sheet, then create new sheets with name...