change

Okay, I create a combo box in my form, to work with a query below. It is supposed to search for two columns in the query. It works at first. Then, I change the combo box to sort ascending and then it goes bonkers.. When I click on a name/area (my two fields) it will find the name but a...

Hello, I have a column that is conditionaly formatted. Cells change there fill colour depending upon the value. My cells change to red if the value <-0.1. Then green appears when the value>0.1 I have used rules type "cells that contain". but at the moment empty cells fill green. How can this be...

How can I change sheets based on a userform button. If I have a command button on sheet 1 that when it's clicked a userform pops up. But I also want to automatically change sheets to the current day. So say on sheet 1 there's a command button for Monday, Tuesday, Wednesday, Thursday, Friday...

ok, so i redesigned a template, but what i shoul;d have done is use a new workbook because every time i type something in the template, the font color is red. is there a way to change it so that it's black?? using excel 2010.

I found this thread to set a background color to the column header of the column with an autofilter applied. It works fine on the Worksheet Activate event, but not for the Worksheet Change, Calculate, or Selection Change. Not sure which on I need, but I'm just looking to apply the background...

Hi all, I have a protected sheet, where I want the users to be able to change the size of the columns but not to hide them. In the option "Protect sheet" I can unable "Format columns", but If I do that, the users will not be able to change the size of the columns. Is there a code for this...

Hi there! I want to loop through an array looking for the below values. IF it finds them, I want to change the value, if it doesn't, just move on. <colgroup><col></colgroup><tbody> 10 Very Easy 10 Demonstrated Well 10 Very Satisfied 1 Not Demonstrated 1 Not Satisfied 1 Not Easy...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I have a formula sumproduct running in the VBA =SUMPRODUCT(--($I$8:$L$8=C8:F8)) I want a loop once this formula is filled restart again filling with change of row number =SUMPRODUCT(--($I$9:$L$9=C8:F8)) change as long as data find in the column C...

Hi All, i have a workbook, which saves as pdf and xlsx. it works fine & the code is below i'm trying to get it to change cell J4 by 1 before it closes. so it changes from number one to number two and so on before it closes. i have a code that i can get it to work by entering the code in...

Hi, So i have these spreadsheets with database connections and which then get uploaded into a datamodel. Now my question is specifically about the data model, if i change the source to a different table with the exact same layout it works great and i don't need to do any editing all the DAX...

I hope the title is accurate. Looking for a solution through Conditional Formatting for the following: Values in cell L14 AND L15 change. (Both values in L14 & L15 shown to user of WB are a result of a formulas placed in those cells that draw from info somewhere else in the WB). When the...

Hello everyone. I'm running Windows 10 and Office 365. I'm looking for a formula or formulas to automate my spreadsheet. Right now this is what I have. Book1ABCDEFGHIJKLMNO11234529/1911022282940200My data is in cells A1:F250.39/1861011162540200Numbers in row 1 goes from...

I would like to find out if it is possible to remove lines from reports I download daily. The lines change position, say lines 20-22 could be on one report and the next day the same report shows the lines I want to delete on lines 30-32. The last line always contains specific words "data can...

Sheet1 is data Sheet2 is data with fill color Abit hard to use conditional Formatting as i have at least 411 data with fill color Is there anyway to do it?

Can you change the Criteria in a Query using VBA? I have a query [qry_OnTimeDelivery_MetricData]. In that Query I have a Field [MONTH0_Active]. What I want to do is from a form, if the User Clicks a Button, the Criteria for MONTH0_Active changes to Like "1" Right now I have an unbound...

I was trying to create a macro that when I open a workbook that is macro-enabled I could simply run some code that will change it to an xls or xlsx and save it as the current file name. I need it to save it to its current location. Thanks as always

Hi great people I have a work stream spreadsheet that I sort by date, the only thing that I'm.struggling with is the height of the rows based of column A containing the number 1, and then colouring the row (A to M) being dark grey Can anyone help me?

Hello, I have a userform with a label "txtRest" using the following code to get the total amount. (this code is in subroutine "txtTotal_Change") Me.txtRest = (IIf(Format(Me.txtTotal, "#,##0") = "", 0, (Format(Me.txtTotal, "#,##0"))) + 0) - (IIf(Format(Me.txtPaid, "#,##0") = "", 0...

Hi I just watched a video of excelisfun, the link below and he suggested to change text to numbers by using -- in front of a function Right(). My question, why he did not suggest to go to Home-->Number--> then select number to convert to text to number. Another question. If I have the...

My speadsheet calculates the 15% and 20% weight loss from a start weight and the cells automatically change orange or red But I also need a formula which calculates the daily change in weight expressed as a % , whether increase or decrease, this can be shown as green cells and ideally when...