-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
clarity
-
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...- zendog1960
- Thread
- answer blank cell clarity formulas
- Replies: 2
- Forum: Excel Questions
-
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...- vikny11
- Thread
- clarity vba
- Replies: 0
- Forum: Excel Questions
-
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...- darenw
- Thread
- clarity design human factors
- Replies: 1
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
GENERATING AN EMAIL FOR EACH SHEET (insert sheet data between 2 sentences of email body)
- Started by JuicyMusic
- Replies: 29
Good Mooring, I have been using a code that splits data from the "Source" tab into separate sheets. Each new sheet that is created ends up... -
Enhance existing VBA for multiple loops
- Started by ItalianPlatinum
- Replies: 27
Hello - looking for a way to expand my loop to also run off another loop. What I mean is it runs for all Items for each date. Currently I have it... -
VBA Destination range is not large enough..
- Started by afc171
- Replies: 27
Hi all, I am coping a selection of data to another sheet but keep getting message that the destination range is not large enough to accommodate... -
Copy and paste same sheet from multiple workbooks to different sheets on master workbook
- Started by Excel_Newbie4980
- Replies: 26
Hello Everyone, Currently, I have a report where I have to copy and paste the same worksheet name "CENTER DATA" from 10 different workbooks into... -
Alternate Number Positions
- Started by cotech_10
- Replies: 25
Hi All I would like to do the following [B][U]SCENARIO 1:[/U][/B] I would like to produce output based on alternate step factors for... -
Why is this a runtime 91 error?
- Started by vbaNumpty
- Replies: 24
I am following a tutorial that demonstrates how to use advancedfilter and find functions in VBA code to populate a list box and allow for editing...
