title

Hi Everyone, OK so on my welcome sheet I have 6 questions all need to be answered before you can move on. so what I need is this. The Titles are in column D in colum G I have a 1 if its not filled in and a 2 if it is. So I want a macro that when runs looks at these cells G14,G16:G18,G20 only...

I need to insert title rows repeatedly at regular interval say once in 18 count to the below workbook which has merged cells (Merged cells are, AB, CDE, FGH, IJK, L to AL, AMAN ,AOAQ,AR TO AX The title rows are kindly just me any automatic method to insert this title rows since it is...

Can someone help me with this please?! I need code in my spreadsheet to stop users having access to the "title bar". I have VBA written so there is a "close button" on my spreadsheet so the user closes the sheet (and saves automatically) EDIT: I do not need the code to do anything else, as...

Hi, I am wonder how can i get the result as in "Auto Number" column: <tbody> A title B Title C Title D Date Auto Number A1 B1 Yes 28-Jun-18 1 A1 B1 Yes 28-Jun-18 1 A1 B2 No 22-Jul-18 1 A1 B1 Yes 23-Jul-18 2 A4 B4 Yes 20-Aug-18 1 A5 B3 Yes 23-Aug-18 1 A5 B3...

Hi, I now how to count cells that contain certain numbers in a range but how do i count if a number appears in a certain selection of cells. In the example below each there are 4 repeating columns. I would want to count how many time a 7 appears in each column with the title "C" which would...

HI Everyone, Does anyone know if it possible to change the colour of the Userform title Bar from Blue To Green. Our sheet has a green theme and the Userform look odd with a Blue top. Any methods tricks workaround would do. Thanks Tony

Hi All, I regularly receive a rather poorly put together spreadsheet and I am putting together some macros to make it usable! I've run into an issue where there is a merged title row that will always contain the word "Clinic". This row number can change regularly. The rows that I wish to...

Bear with me, the title was confusing, but the description will make sense… My company sells essential oils with title x, and associated size, with different part number for each size. The part number is the same for all sizes within one title…i.e. Tea Tree essential oil – the sizes are 1 oz, 5...

EDIT: How do I attach an example workbook?? Hi, I have recently posted on a different Excel forum with no luck relating to my current issue. The workbook in question is a tracker of mixed-martial arts fights. The issue relates to tracking the current and past champions. I am trying to fill...

It's been a while since I have posted, so not sure if I am posting correctly this time. I have an issue with conditional formatting in cells D6:D14. In Column D a response is returned depending on what is input in C13. The effect I am trying to achieve is where there is no value in C13, then...

Good morning, I was wondering if someonecould give me some help on a formula. First of all, a bit ofbackground. I have 2 tabs Tab 1 contains data presentingdifferent projects, sometimes pack of the same package. <tbody> A B C D E 1...

Hello, I have an issue which I have not found a solution for. I have a chart that links the axis titles to a cell in worksheet tab (=Data!$A$6). I also need to reset the axis title for alignment (long issue). The code I have is Dim Axs As Long Dim AxSide As Long Dim Tstring As String...

I'm fanatic user of Excel 2003, using VBA coding with no problems. I try now to work with Excel 2010 but facing problems with the "title bar" and the resizing of the sheet when double clicking the title bar. Is any VBA code to remove the "title bar" and disable the double clicking on it? I...

Hello everyone I have a macro below to open and close toggleButton (Tog1; Tog2; Tog3), only one at a time, in userform1. "MODULE" Sub TogClick (tog as ToggleButton) Col collection static like Dim ctl as control Dim vCtl as variant If col is nothing then Set col = New Collection For each ctl...

Hello Sirs! I have a file that lists a title as of a certain date. In the columns I have Employee Number, Title, effective date of title. Take one for example: Emp No Title Date 5298 Staff Acct 7FEB2007 5298 Staff Acct1 8MAR2009...

The Excel Menu Top Left contains option for Move, Size, Minimize, Close Is it possible to add/remove options to that Menu - Such as Remove Minimize - Add Print, Save, Etc? Is it possible to change Color of Title Bar? Thanks

<tbody> Employee Name Title Salary max sales min sales Archie Moody TI 14 327 96 Dixie Daniels T3 35 170 109 Jennifer Palmer T5 16 320 317 Camille Ortega T3 12 257 213 Arlene Carr T2 12 289 240 Neil Mills T1 17 352 116 Terri Bridges T4 38 172 110 Terrell Cortez T1 30 292 105...

I currently have several charts that show the Top 5-10 items in a list. Currently, the chart sorts it by lowest to highest. In trying to figure out how to have it sort from highest to lowest, I located the "Categories in Reverse Order" option within the Axis formatting, however when I click...

Hi, I want to be able to search a policy number and get the appropriate info in the same sheet. I want my header to adapt to the type of information. Let say my header is on A1 through Z1. This sheet is all my data set. A2 and below are my policy numbers, B2 and bellow are my insurance type...

I need some help, i have been scouring for an answer on this one and i have hit a wall. Here is my question, buckle up and hopes i can explain it right. I have 2 work books. One contains job titles that come from a database in its own format - Call it book1. The second workbook has my master...