clarity

  1. zendog1960

    Changing cell values that are empty using formulas

    It's been a while since I las posted anything. I has trying something in excel but I am not sure if it's possible. Here's the problem: A1 is a blank cell. No formulas or anything. B1 let's say has a value of 1.33 In C1, I would like to create a formula that will if B1 is not blank, the make...
  2. V

    VBA to Connect to CA Clarity PPM

    Hi, I am trying to download resource names and hours for a specific project from CA Clarity PPM using Excel. I need the macro to access clarity PPM(www.abcd.hosting.ca.com) using username and password and download resource details if login is correct. Any suggestions how this can be done using...
  3. D

    Making it clear what user may modify or spread formulas over

    We have a complex spreadsheet where it's not always clear which cells should be modified and which should never be touched in normal use. It's especially error-prone to have an area filled with formulas, but due to a few exceptional cases some cells have just a number or something else. Are...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    • Replies: 31
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    • Replies: 26
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    • Replies: 24
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    • Replies: 23
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    • Replies: 23
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    • Replies: 23
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top