change

Morning I have been tasked with "fixing" and excel template created by someone else who no longer works for the company. We fill in the template, press a "clicky" then it saves and send the completed template to the client. The issue is that the company images that appeared in the E-mail are...

If Not Intersect(Target, Range("K12:T31")) Is Nothing Then If I want to change the range to K12:Q31 and S12:T31 - what should I do? TIA

I am creating many line graphs and would like to know of a way to change the vertical axis bound minimum and maximum based on the data itself? For example for set of data, the amounts ranges from 6 million to 12 million while another data set ranges from 3 thousand to 5 thousand. Same graph just...

Hi All, I am trying to create a column that is basically, giving the variance of this week, to the previous week. I want to make this as automated as possible. An example is below: So in the table there are 5 columns with 5 dates, and I need in the 6th column to have O2-N2, and I need this to...

Hi, I want to change 4-5 cells black if one of the cells contains the work remitted and if that cell is blank change it red. Can anyone help I have tried various ways and can only make the cell with remitted change colour.. Thanks :-0 Toni

Dear All i have a data base and i need to change back ground color of a cell based on value of another cell in the same row. for an example, how to change color of A1 , if C1 got a date value (only type of value)? other types are email and blank. so I need to change 3 different colors...

I have a Complete Dt column with the date formatted as 10/8/2019 and I need a formula to convert this to the name of the month. Any ideas? I tried this but all I get is January in the column. Format(DatePart("m",[Completed Dt]),"mmmm")

Hi all. I have a spreadsheet with 90+ charts on, and need to change the cell references by 2 columns (i.e. from column G to column E). Is there a quick way to do this without having to go in to each chart manually? I tried recording a macro, but instead of just replacing the G for E it types...

Hi everyone, first time posting, but I can't seem to find the solution. When I encode 11/3/19 in a cell, when formatted it would show March 11, 2019. I would like it show as November 3, 2019 instead. Is there away to change this. Thank you very much.

Hi would appreciate any assistance here. I have a cell in sheet Fig 2 that has multiple names. this cell brings names based on a macro from Master_Data sheet. I would like to be able to know who is male and who is female. In Master_Data I have a column which specifies female or male, Column D...

HI, I am trying to loop through all the cells in thisworkbook and change the background color to vbyellow. My code so far is as follows: Sub testdata() Dim nm As Variant For Each nm In ThisWorkbook.Names Range(nm.RefersTo).Interior.Color = vbYellow Next nm End Sub It draws an...

Hello, I need help with a bit of VBA code. I have columns AIFinal01-AIFinal20 throughout my sheet. Each column contains a formula going to the bottom. I need to change that formula to a value for all 20 columns. The columns are not in direct order and their are columns between them. Any help is...

is there a simple way to do this so that it's not PC dependent ? change the settings within the workbook? rather not use formulas

Hi, Can't attach the the file to the post as there is no option to do so which I need help with but this is where the file is located: https://trumpexcel.com/excel-leave-tracker/ What I want to change in this file is to include “IN” and “OFF” on the calendar days that employees are working and...

Hi, I have the following code which calculates a weighted average: =SUMPRODUCT(--($U$2:$U$1203=AE3),$AB$2:$AB$1203,$C$2:$C$1203)/SUMIF($U$2:$U$1203,AE3,$C$2:$C$1203) It works very well except that I would like it to ignore blank cells in the range $AB$2:$AB$1203 I tried to change it to the...

Hello How is above statement in RED justified with below code as i am stuck and color does not change when the mouse is outside the border or edge of command button Private Sub CommandButton1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Single, ByVal y As Single)...

Hi No matter how I enter the time in excel, excel will change the format to Custom (h:00:00 am/pm). Why excel does not change the format of the time I entered to "Time" instead of "Custom" ? <tbody> I entered excel convert custom 1:00:00 am 1:00:00 AM h:mm:ss AM/PM 1 am 1:00 AM h:mm...

hello I have found this code how do I change the code to only change the selected cells to turn white Cells.Interior.ColorIndex = 0 Cells(A12:AE39).Interior.ColorIndex = 0 I only want it to work on A12:AE39 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count >...

Hello I have a sheet but in struggling to see if I'm on the correct row when im filling it in Can you change the row colour when a cell is selected? ie: if I select any thing between G21:AE21 I can get A21:E21 to change colour But if nothing is selected then don't change anything Hope ive...

I already have a script that does most of the mumbo jumbo of what I need, however at the very end of that script, I want to add the part to rename part of some of my sheets to something else I have multiple template sheets and a master sheet within a workbook, those need to remain untouched...