titles

Hello all, I have a For Each statement piece of code that adds a value to a column at the end of my report. My current code is processing 30k rows in excel and runs in 40 seconds. I was hoping someone may see a better way to write the code I have in a more efficient way to speed up the run...

MrExcel I have been working with using your Pivot table drilldown vba code (Thank you for it!) but I have found that any titles with a special character i.e #, can not be formatted or hidden. I see in your code the section "For Each rCell In rFieldFormats. Resize(, 1)" that I think maybe...

I've been building up an organizational chart for where I work using the Excel SmartArt. Currently I'm using the Name and Title template. I was wondering if it is possible to somehow add additional titles to all the boxes. Below is a quick example similar to what I currently have built up. I'm...

I have a central tab called "Summaries". From this tab, I'd like to assign a macro to a button that separates out new worksheets based on titles starting in cell B5, with the name of the tabs matching the titles. Sometimes, the number of titles can vary but they will always begin in cell B5. In...

Hi All, Could someone please assist with the below query as I couldn't figure out the way to do it. I have two columns(A&B) with document numbers (same numbers exist in column A due to multiple versions- draft, version 1, final etc) and Titles. Some document numbers have same titles, which...

<tbody> Cost Center 1234 Total Cost Center 1234 </tbody> I have a table of information where, in column A there are title showing the beginning and end of each group. I want to fill down these titles. In the example above, I want to fill down the Cost Center 1234 in the empty...

Hello I am trying figure out the best way to figure out how to get the total # of rates per title in a given range. the rate ranges are uneven intervals. ex master sheet a list of titles column A a list of different rates column B sheet 2 has the list of titles no dupes and the rate ranges...

Question for you. Sheet 1&2 name titles need to be changed with the following titles: Sheet1= PrePaidReport, Sheet2 = NewFormat, after I made the changes inthe VBA Script, Sheet titles change to capital letters, then I get, "Compile error" displays, "Variable not defined".

Hi I've got a csv file with dozens of column titles in one cell. Please find below the first 4 column titles, to give you an example of the data. Sales_metric|Volume_metric|Promo_id|Zone_id| Does anyone know how to extract the into separate columns so "Sales_Metric" would appear in one...

So I would like to make spreadsheet of my music titles. But all I can do is copy the text so it all reads in one column. What i want to do is to parse the data into separate columns. so this "3 Doors Down - The Better Life - 01 - Kryptonite.mp3" wood split at the "-" to have 4 columns. Can...

Hi, I build a template in multiple languages. I therefore set up a named range "Language" that can be "Fr", "Eng" or "Nl" (those values are not stored in any cell but through a userform when opening the template). All my titles are looking up on this value so everything in the forms changes...

searched a lot for this but could not get answers how to repeat specific rows starting from page 2 not in the first page:( thanks in advance

In a workbook I have titles to a table in Row 2. I want to set a named column based on those titles as publicly accessible throughout all of the code in the workbook. I'm currently getting a Compile Error: Type Mismatch with .Match being highlighted. Thoughts? Public ColPWSN As Range Set...

I have a macro that applies protection to ranges in seven worksheets. It gives the ranges a title (required parameter) "Range1"..."Range7". The problem I have is that if I want to turn the protection off and then reapply it by running the macro again, the macro fails because "Range1"..."Range7"...

Exactly what the thread title says. I want to copy the pivot filters from PivotTable1 to all other pivot tables on the sheet with matching filter titles. I want this to occur after the click of a button. I found this code on Contextures from Jeff Weir, but it is not working for me. Any...

I am trying to figure out a tidy way to write the following scenario. Worksheet A Has a list that, from project to project will vary in the number of rows in it. Example of information in Worksheet A. Data to be used in Calendar Month column. <tbody> Calendar Month Start Date End Date...

What I need is a little more than what I could fit in the title the 3 steps are illustrated below and there is a gdrive link for the example file. (I could not work out how to create editable cells in a post; (tried it in a test thread). Put simply I have titles associated with codes. I need to...

Hey, I have multiple files in multiple subfolders that have data in them that I would like placed into rows along in the workbook the macro is run from. A couple points to note are: -The files are all going to be xls files of some sort -The folders and subfolders will contain various other...

Hi I want to create a dynamic list that looks up one of a range of criteria and creates a list. There are 14 criterias in (for example), cells A1:A14. All of them uniquely different (they are job titles). I have a list of 100 staff members with their names and job titles in columns C and D...

hi friend i have Excel in spanish language: i have this formula: =TRUNCAR(BB5721/N5721,4) and have so so 2000 rows.. (intermediate have other formulas) ... i want replace by: =TRUNCAR(BB5721/U5721,4) note i cant write it in first cell and copy to all rows, because i have intermediate...