# Search:

Type: Posts; User: chet645; Keyword(s):

Page 1 of 2 1

1. ## Thread: Dynamic Loan Draw Formula

by chet645
Replies
1
Views
75

### Dynamic Loan Draw Formula

Hi All, I am wondering if I can enlist this forum's help. Can someone help me create a dynamic loan draw formula (highlighted row 10 in HTML table below) with the following constraints:

- The loan...
2. ## Thread: Loan Draw - Dyanamic Formula

by chet645
Replies
0
Views
57

### Loan Draw - Dyanamic Formula

Hi All, I am wondering if I can enlist this forum's help. Can someone help me create a dynamic loan draw formula (highlighted row 10 in HTML table below) with the following constraints:

- The loan...
3. ## Thread: Data Table Calculating But No Data Table

by chet645
Replies
0
Views
120

### Data Table Calculating But No Data Table

All, I have two workbooks that I copy and paste certain values and formats from one workbook to another. For some reason, when I paste the values, the workbook from which I am copying the data from...
4. ## Thread: Conditional Sumproduct Formula Error

by chet645
Replies
3
Views
231

### Re: Conditional Sumproduct Formula Error

Thanks, Eric! Works perfect.
5. ## Thread: Conditional Sumproduct Formula Error

by chet645
Replies
3
Views
231

### Conditional Sumproduct Formula Error

All, I am using a conditional sumproduct formula that references another table to calculate a value. The other table has ='"" values in some of the arrays so the sumproduct formula returns #VALUE !....
6. ## Thread: Copy Paste Macro

by chet645
Replies
7
Views
434

### Re: Copy Paste Macro

would it be helpful if I posted the entire macro?
7. ## Thread: Copy Paste Macro

by chet645
Replies
7
Views
434

### Re: Copy Paste Macro

The macro selects and entire worksheet in a target workbook, then pastes it into another workbook for consolidation purposes.
8. ## Thread: Copy Paste Macro

by chet645
Replies
7
Views
434

### Re: Copy Paste Macro

Hi Mark, great idea. I'm a novice VBA user, but when I scroll through macro step by step, it gets caught in a circle and can't get out. The circle happens here:

For Each myCell In Selection
...
9. ## Thread: Copy Paste Macro

by chet645
Replies
7
Views
434

### Copy Paste Macro

I created a macro that opens a workbook, copies information from that workbook, then pastes the information into a "destination" workbook. The problem is, conditional formatting exists in the...
10. ## Thread: Copy / Paste Macro

by chet645
Replies
4
Views
128

### Re: Copy / Paste Macro

Sorry, just want the macro to paste the values, lol.
11. ## Thread: Copy / Paste Macro

by chet645
Replies
4
Views
128

### Copy / Paste Macro

I am trying to use the more efficient way to copy and paste values using a looping macro. The code below doesn't seem to be doing what I want it to. I don't get an error with the line of code below,...
12. ## Thread: Faster Goal Seek / Copy Past Macro

by chet645
Replies
2
Views
2,237

### Re: Faster Goal Seek / Copy Past Macro

I was reading some stuff on-line, and it looks like my copy and paste code is pretty inefficient. I read that the following...
13. ## Thread: Faster Goal Seek / Copy Past Macro

by chet645
Replies
2
Views
2,237

### Faster Goal Seek / Copy Past Macro

All,

I have created a macro to automate a bunch of scenarios I am running in a financial model I've built. The ultimate goal is to automate 30K+ scenarios with my macro. The problem is, the macro...
14. ## Thread: XLSB File Opening Slowly

by chet645
Replies
3
Views
1,244

### Re: XLSB File Opening Slowly

Everyone is on 64bit OS. We are on a network. We have tried saving locally but doesn't make a difference.
15. ## Thread: XLSB File Opening Slowly

by chet645
Replies
3
Views
1,244

### XLSB File Opening Slowly

All, I have a fairly complex 6MB financial model saved in xlsb format that is having difficulty opening up quickly (it takes 60 seconds or so). Strange thing is, on some machines the model opens up...
16. ## Thread: Conditional VBA - Manual Input vs. Formula

by chet645
Replies
4
Views
317

### Re: Conditional VBA - Manual Input vs. Formula

I agree, if I was just trying to change formatting, I would simply use CF. The hard part is making the cell toggle back and forth between and input cell and a formula cell (see my reply to My Answer...
17. ## Thread: Conditional VBA - Manual Input vs. Formula

by chet645
Replies
4
Views
317

### Re: Conditional VBA - Manual Input vs. Formula

The dropdown box is located in cell v69. When the dropdown box is toggled to "manual," I would like the vba code to clear out the formula in the cell to the right (w69) and replace it with a simple...
18. ## Thread: Conditional VBA - Manual Input vs. Formula

by chet645
Replies
4
Views
317

### Conditional VBA - Manual Input vs. Formula

Hi All, I am trying to write some code that will allow me to input a value in a cell (and change the font color and cell color) if a drop down menu is toggled to say "Manual." I am not an extensive...
19. ## Thread: Restricting cell inputs

by chet645
Replies
2
Views
152

### Restricting cell inputs

I am working on a financial model and am wondering what is the best way to restrict a user from entering a value in a cell if another cell has a value greater than zero. I would like the restriction...

by chet645
Replies
2
Views
209

### Re: Commercial Lease

Thanks for your reply Noodleski. See my example below. The idea would be that I could input a value in the blue font cells and the Total Lease Commission Due would change dynamically. I can do this...

by chet645
Replies
2
Views
209

### Commercial Lease

I am trying to develop a formula that will calculate a lease commission for a commercial real estate lease, in a single cell, using several lease parameters and without creating a lease cash flow...
22. ## Thread: Model Calculation Efficiency

by chet645
Replies
1
Views
152

### Model Calculation Efficiency

All,

I have built a model for my job that incorporates quite a few array functions (they pull data from tabs in the workbook). The file is only 1MB. I understand that array functions can slow down...
23. ## Thread: Array Formula Not Working

by chet645
Replies
5
Views
282

### Re: Array Formula Not Working

For some reason that doesn't work. here is a sample of how my data is set up.

<tbody>
Column A
Column K

02/27/2014 Wed
\$3.50
24. ## Thread: Array Formula Not Working

by chet645
Replies
5
Views
282

### Re: Array Formula Not Working

This is a sample of what the dates look like in Column A

02/27/2014 Wed
03/26/2014 Wed
03/25/2014 Tues
03/25/2014 Tues
.
.
.
.
25. ## Thread: Array Formula Not Working

by chet645
Replies
5
Views
282

### Array Formula Not Working

I have created a conditional array function that sums values in column K between two dates. When I break the formula up, the individual parts seem to work. However, together I get a #value!...
Results 1 to 25 of 47
Page 1 of 2 1