appears

Hi I've developed a worksheet with a rating scale. I've been attempting to code where if an exclamation mark occurs, a pop message appears. However, the pop up message only appears when I double click on the cell where the exclamation mark (!) occurs. My desired outcome is when the exclamation...

Hi, Trying to sum multiple columns from another sheet based on one criteria, which is determined by the "MID" function. What is wrong with the formula? 1) B2 (formatted as text)=9132456, 6753456 2) 6753456 appears in D:D (formatted as text as well). It has 100$ in col. P and -10$ in Q. Should...

Does anyone know how you can format one digit in a cell without formatting the rest without having to do it manually every time ? For example if 53 appears in a cell I would like for the 3 to be red and the 5 remain black. Every time the 3 appears in my data I want the 3 to be red, for...

Hello everyone, I need help with conditional formatting formula. The 1st range of values in cell range R10:R12 Example R10 = 9 R11 = 8 R12 = 2 The 2nd range of value in cell range R18:R20 Example: R18 = 3 R19 = 5 R20 = 2 Ok this my question. Notice the value appears twice in cell R12 and...

i have a rather long routine that I would like to fire off during my lunch break. I will have the work book open, and I have added the necissary code to the workbook_open event Application.OnTime TimeValue("13:00:00"), "AFK UPDATE" However my PC is set to lock after a few minutes due to group...

Hello: Excel 2010CDEFG1NameInvoice NoDuplicate invoice2Peter Paul121245no3PeterPaul121245yes4Tiffany5675225yes5Macy5675225no6Tiffany5675225yes7PeterPaul121245yes8PeterPaul1524456NoSheet1 If name in column C and Invoice No in column E appears more than once, required result in column G...

I am looking to use format cells options to have a prompt that shows up in the cell to give direction such as "Enter Work Code Here" or " Work code Here" when there is nothing in the cell. Once its been entered, the messages is not long displayed unless the number and letters are entered...

Hi Folks, I have a TextBox/SpinButton Combo that works fine, except that I notice an odd artifact when directly/manually changing the (numerical) value in the TextBox... It acquires an Underscore during input. This does not happen when changing the value via the SpinButton. :confused: The...

Hi - Is there a way to say look in A10 and if the word "March" appears, put "March" in B10? Thanks!

I wish to give a workbook to members of our group. It contains a listview control, but it appears that control is Missing (even though it was in the xlsm file I gave them). I thought adding a Reference would fix this, but it appears not. Is there a solution for this? Thanks,

I have a table I am working with that has project names that are listed multiple times (along with a bunch of other data that should not be relevant here). This is in Power Query What I want to do is a running total of how many times the project name appears then start the count over when a new...

Hi all, Hopefully an easy one. =SUMPRODUCT(($C:$C="Equity")*($E:$E)*(B:$B)) Essentially want to multiply and sum Column E and B together if C = "Equity" Columns E and B contain empty cells, which appears to be the root of the problem. Any ideas? Thanks, John

I have got to be missing something simple here. I have the following code where "1" appears 3 times and "5" appears 1 time in Range("A1:A25")... =COUNTIF(A1:A25,OR(1,5)) Which I would think should return "4", but it is returning "0"... Does anyone have any input? (web searching isn't really...

I am having a problem with trying to make sure that i do not have any duplicate names on a worksheet as well as on any other worksheet. I have 13 Sheets and if John Doe appears on one of the sheets I would like for it to turn red to indicate that i have a duplicate on other sheet. Is this...

I'm looking to sum the column totals in column O to T and have the totals appears in Cell O1 to T1

I am having a tough time with a simple formatting macro. For sheets 1 and 2 in my workbook, I need a macro that will move the following dates to the bottom of the data, and highlight the entire row in which the dates appear in yellow. The dates are: 7/1/1977 (appears in sheet at Jul-77)...

I have broken out my pivot table by a filtered field so now I have numerous tabs. I want to be able to set Rows to repeat at top for all of these individual tabs but that option appears to be grayed out. Thoughts on how to accomplish this?

Hi I have a cell (D45) where if the value exceeds 12, a dialogue box appears when worksheet_deactivate. Works fine, but if the cell is not amended then the message box comes up every subsequent time there is worksheet_deactivate. Can I specify that the box appears a maximum number of...

What is the best way to count how many time text appears in a cell? For example: 1a. Behavioral health issues;#19a. Relationship (spouse, failed intimate relationship, close friend, etc.);#21a. Substance Abuse (History of drug and/or alcohol abuse) Count how many times just "a." appears in a...

I have a worksheet where I want a message box to appear when the letter "A" appears in the range I37:I69. I used to following code to accomplish this: Private Sub Worksheet_Change(ByVal Target As Range) If Not Range("I37:I69").Find(what:="AA", LookIn:=xlValues, lookat:=xlWhole...