1. D

    Sign off based on 2 mandatory cells

    Hello, hoping someone can help me with this Excel VBA question. Column T is the sign off column. In order to sign off, Two cells are Mandatory. 1. If column L contains ICP, then, Column O should have a trading partner. 2. Column N should have a Text. Thank you.
  2. D

    Adding a Minus Sign with a macros

    I need to add a minus sign in front of a number in cell G8 and one in H8. Thank you for your time
  3. A

    Generating Sign In Sheets from a Master Schedule

    I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...
  4. J

    Ampersands Appearing in Formulas

    I have recently been experiencing something I have not seen in my fifteen years of working with Excel: @ signs are appearing in my workbooks formulas directly after the = sign. For example...
  5. J

    =UNIQUE coming to O365?

    Hi all Does anyone have an ideas of when the new array formulas are coming to excel O365? They were released to insiders exactly one year ago now but still no sign for normal users. Apologies if there is already a thread on this, I I did a quick search but couldn't find Thanks Joe
  6. M

    Insert text before the @ character from email address in a cell

    Hi All I know how to insert characters x spaces from left or right, but in my column have a list of email addresses.They are all completely different and vary in length an characters before and after the @ sign. As an example I would like to change to and...
  7. C

    Decimal signs "," & "." - causing issues

    Hi, I have a template that calculates costs for services per month based on input from managers. I have set dot/"." as default decimal sign whilst everyone else have comma/"," (applies to all excel files you open). Due to this, they can not see the calculated costs for rows that contain cells...
  8. M

    Clear “ – “ sign before continue with code

    Hi can someone help please I have the following VBA code which is in my worksheet 3 known as “IN” and what this code does is basically cuts and pastes the cell content under column A from my “IN” sheet and pastes it into column C in my “OUT “sheet, but because the “OUT” sheet 4 has a “ - “...
  9. E

    Insert formula if CheckBoxes.Value = xlOn

    Hi I want to insert a formula in the cell left to a check box, if the CheckBoxes.Value = xlOn : Sub test() For i = 53 To 102 If ActiveSheet.CheckBoxes(i).Value = xlOn Then ActiveSheet.CheckBoxes(i).TopLeftCell.Offset(1, 0).Formula = ("=2+2") End If...
  10. B

    barcode and description

    hi im scanning barcodes into A column and want b column to put description of item in column in B I am trying to create a inventory sign out, sign in page for search and rescue Thanks Barry
  11. E

    How to merge cells without pasting formatting?

    Hello! I have merged cells A1-A3 and I want to drag this and merge B1-B3, C1-C3 etc. However, dragging the + sign copies also the formatting, not only the merging. Is there a solution? Thanks!
  12. I

    VBA macro

    I have 1700 hundred record some are debit and some are credit I need to move credit value in debit column with negative sign as value
  13. T

    Link to "<" or ">" in an excel formula

    Hi, I have a formula that says =if(A1>A2,"True","False"). However, I want the ability for the user to change the sign in an other cell. So let's say in cell B1 they can enter ">" or "<". I want to write a formula something like this =if(A1&B1&A2,"True","False"). This does not work. How can I do...
  14. A

    Need $ Sign Visible In Custom Number Format

    [<=1000000]#0.00,," K";[>=1000000]#0.00,," M";0.0 Hi Folks. What would I do to make this custom format display a $ sign followed by one space prior to the number? So instead, for example, of 5.21 M it would show $ 5.21 M. Thanks in advance for your time!! Best, Aimee in Madison
  15. F

    VBA Filter with criteria and offset

    Hello, I am filtering column A (the only column in the sheet) for all rows that begins with an @ sign. The delete all rows that do not start with an @ sign I have some code which does this OK. However I also want the filter to return the row directly above the one found with the @ sign. And...
  16. V

    Vba concatenate 2 columns that have a currency

    Hi all, Any advice would be appreciated on this! Column P of my workbook is a numerical column and Column Q is a Currency sign indicator, I need to add the Currency sign indicator to the front of the cell in column P or at the end depending on the currency sign indicator. £ = UK Pounds P =...
  17. adrienne0914

    Custom Number Format

    I would like to create a custom number format where millions are displayed as thousands. I know the formula for that is #,##0,;-#,##0, My problem is that I also need to add an accounting offset dollar sign. So I need $ 1,000,000 displays as $ 1,000 with the dollar sign in the same position...
  18. M

    Highlight certain text in a cell - with varibles

    I have a large excel spread sheet with the following characters repeated: (CD #####). The #### are replaced for different situations. For example one instance might be CD 1-1 or CD 13-5, etc. I have seen that there are VBAs that can be used to color texts but I am looking to HIGHLIGHT the...
  19. K

    nested if formula with true or false condition

    hi, I need a "if" formula with below case in cell A1 i have amount 55000(positive), in cell B1 I have sign "+". similarly, in A2 i have amount -25000 (negative) and in cell B2 sign "-" . the signs +/- are manually input based on requirement.. now the formula should tell me if the amount in A1...
  20. K

    nested if formula with True or False condition

    hi, I need a "if" formula with below case in cell A1 i have amount 55000(positive), in cell B1 I have sign "+". similarly, in A2 i have amount -25000 (negative) and in cell B2 sign "-" . the signs +/- are manually input based on requirement.. now the formula should tell me if the amount in A1...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...