make

Hi, so i am trying to get one last thing working on my work excel before i leave. I have tried a couple of the macros that i have found on this site, but couldn't get them to fully work. So basically i have 12 cells where they update automatically and i am trying to set it up so they also...

Hi MrExcel group :) To the sheet below, I would like to add another set of stats to separate average days at fledge for males and for females (without trimming the mean). Male and female designations are in the name column. I should be able to do it as is without making a separate column for...

I have an Excel formula that I put together to consolidate the content of a whole grid of cells into minimally formatted bullet lists. However I have had to cut it off before the character limit. What I am doing is taking data exploded into discrete elements and pulling it into a cell, to...

Hi everybody I have generator password in excel, but sometime, my password have dulicated character, which make my password less secure, can any one help me with the fuction to help my password not have a dulicated character. My password is in G1, the ingredient to make my password is from D5 to...

Good Day Ma'am's and Sir's I am currently trying to make a working system for sales and inventory. I need some help coding for which i have a userform which has 1button and 1textbox, which when you click the button the textbox display a number 1 value, and every time i will click the button the...

Hello everyone, I have a spreadsheet that the rows are labeled 1-31 and data gets entered into it every night at midnight and then the sheet gets saved at the end of each month and a new is started. I want to make a user form and have text box 1 automatically have today's date generated when...

I have a program and I have some code that deletes columns from a table starting at week 2 and going to the right to the last column. I recorded the syntax from the Excel VBA recorder and it has quite a few lines. I want to condense it, so there aren't as many lines, as well as, make it more...

Hi, I want to format a table in excel to change the row colour when a different value is reached in one of the columns. The value in this column changes every 20 cells or so, so ideally there would be two colours alternating down the table to make the differnet sections obvious (eg make blue...

Hi, In my excel sheet there are 10 columns. If column "E" cell values are equal to "contract" or "permanent", I need to make column "F" and "G" respective raw values are mandatory. Ex: If E5 value is equal to "contract", I should enter "F5" and "G5" values. Highly appreciate , if you can...

Hello, How can I make a range in a macro dynamic? For example, in the macro below, how can I make it pick upnew rows, like P15, added to the range P1:P14? Private Sub Worksheet_Change(ByVal Target As Range) Dim changed As Range,c As Range Dim cVal Const myR As String ="P1:P14" '<- Your...

I created several PowerQuery but I want to hide it. Now, everyone clicking Data > Query and connection can find it. How to make it "invisible" to others ? Thanks

OK here the thing. I have created a sheet for my work that shows financial data. But this data I only want visible based on several conditions( possibilities) To make matters more complicated more than one condition can occur. Also These conditions are triggered by cell value based on a...

I'm attempting to create a table to store all of my functions in. What I would like to do is have power query loop through this table and load in all the functions in said table, but I can't seem to find any way to make this happen. I assume there is a way, I just don't know enough yet about...

Good day! I've dragged Date to the Filter field. When I open the list, I find the entire list not grouped into years>months>days. Is there something I can do to make it happen?

What is the vba to make an entire row not bold?

I'm 99% you can't make a toggle button using code, so can you change the size and location of one via code? I have a few on a sheet and they seem to have resized/relocated on their own when switch computers and it's quite annoying so I was just going to have code (if possible) to ensure they...

Hi everyone and thanks for taking a look at my question. I would really appreciate any assistance! I have created a sales quote template for my company. Some of our sales people use Macs and other use PCs. When going to print a quote, it is necessary to select three different tabs. Sometimes...

HI ALL i this code to save my sheet as a pdf using info from cell c2 Private Sub CommandButton1_Click() ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ filename:="C:\release" & Range("C2") & ".pdf", _ OpenAfterPublish:=False, _ IncludeDocProperties:=True, _...

Hi. Please can anyone help? The dog is one. Last year cover was £115.08 for the year and this year has been quoted as £128.88 which is an increase of nearly 12%. It seems from search of the web that by the age of 8 the premium will have increased by about 34% and when he is 15 it will have...