Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. 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. 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. 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. Replies
    3
    Views
    231

    Re: Conditional Sumproduct Formula Error

    Thanks, Eric! Works perfect.
  5. 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. Replies
    7
    Views
    434

    Re: Copy Paste Macro

    would it be helpful if I posted the entire macro?
  7. 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. 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. 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. Replies
    4
    Views
    128

    Re: Copy / Paste Macro

    Sorry, just want the macro to paste the values, lol.
  11. 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. Replies
    2
    Views
    2,237

    Re: Faster Goal Seek / Copy Past Macro

    Thanks for your help, Joe. Those suggestions made a difference.

    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. 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. 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. 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. 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. 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. 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. 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...
  20. 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...
  21. 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. 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. 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. 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. 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 2