Results 1 to 5 of 5

calculating based on a range of variable depth (VBA)

Threaded View

khajja calculating based on a range... 09-15-2011, 05:47 PM
Chance2 Re: calculating based on a... 09-15-2011, 06:17 PM
khajja Re: calculating based on a... 09-15-2011, 06:43 PM
Chance2 Re: calculating based on a... 09-15-2011, 07:32 PM
khajja Re: calculating based on a... 09-15-2011, 07:38 PM
  1. #1
    Registered User
    Join Date
    09-15-2011
    Location
    Tampa, Fl
    MS-Off Ver
    Excel 2010
    Posts
    3

    calculating based on a range of variable depth (VBA)

    Hi all, normally I have been able to stumble across my own solutions but am having trouble with this one. See attachment for reference. I am trying to have the excess cash flow line calculate as EBITDA less the sum of the expenses below. The first expense is always on line 6 and there are always the same number of years for this (C:J). The number of expenses is variable and could be anywhere from 3-10. This graph is being pulled from data on another page via VBA and should function without user input. This line is the only one I haven't been able to figure out.

    Please point me in the right direction as I have tried this from a few direction, with little success.

    Thanks for looking!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1