• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    SUMPRODUCT in VBA

    OK, this is horribly in-elegant (bordering on the horrific), but it should do the above mentioned task I need (it'll add row numbers in, but I can work around that with conditional formatting), I just can't get it to work correctly. Is anyone able to explain what's up with it (aside from the...
  2. L

    SUMPRODUCT in VBA

    Well, the system has been setup so that only one person can access it at a time (something to do with limiting access and reducing something or other), so it would only need to sort a single persons information a time. Of course, it would need to sort all of that persons leave from the 3...
  3. L

    SUMPRODUCT in VBA

    Does anyone have any idea? I'm just stuck.
  4. L

    SUMPRODUCT in VBA

    Awesome. The spreadsheet is here: https://spreadsheets.google.com/ccc?key=0AuNGIfcbtpZxdFR0U3BvR0tzSC1PVFN4emFGZWRWdkE&hl=en&authkey=COvUqPgL If you look at the 3 staff sheets, you will see that they are identical and that there are 3 sections for leave to be entered, using a start date and...
  5. L

    SUMPRODUCT in VBA

    I have a mock up ready now. How do I attach it? (yep, I'm that stupid)
  6. L

    SUMPRODUCT in VBA

    Hey guys. Found this site last week and love it. It helped me with a query I'd been working on for days. Now, however, my query has increased into something I can't sort and was hoping for some assistance. Basically, I found Chandoo's SUMPRODUCT formula...
Back
Top