voucher

  1. M

    Best way eliminate rows with multiple status from a count?

    I receive data from our ERP system on vouchers that create errors. I want to have a measure that tells me how many voucher lines were closed within the last week. But... a voucher can create multiple errors - one might be closed during that week, but if the same line has an open error I don't...
  2. M

    How to use Table.Buffer to speed queries?

    My queries go against transactional tables with 30-40 columns and millions of rows, and I'd like to speed them up. I see columns by Chris Webb and others talking about how List.Buffer and Table.Buffer can greatly reduce query times, but the M function descriptions are pretty sparse on how to...
  3. M

    VAR inside CALCULATE?

    Hopefully others have encountered this situation. There's a lot I need to wrap my head around in DAX and the order that calculations happen is one of them. I'm not sure whether the following measure is doing what I think it's doing without having to create multiple intermediate helper columns...
  4. H

    Excel VBA copy data from one workbook to another & running macro number of times based on a cell value

    Hello, I have two workbooks one is for making bookings and a second that has a list of numbers allocated to vouchers. Workbook one has data like surname, date of appointment & staff initials. I want this data transferred to workbook 2 which is where we allocate voucher numbers to...
  5. M

    Disconnected table measure not grouping as expected

    I would like help discovering why a disconnected slicer is not returning the expected data. Hopefully I’m missing something obvious. I would like to return a payment schedule based on our Accounts Payable (AP) groupings. The days to pay bucket is the Payment Date (if one exists) - Accounting...
  6. D

    Macro unique number lookup - exact match required

    Hi All, I am using the following code: Sub ReturnInvoice() Do Dim myWord$ myWord = InputBox("Insert the Voucher Number", "Voucher Search") If myWord = "" Then Exit Sub Application.ScreenUpdating = False Dim xRow&, NextRow&, LastRow& LastRow = Cells(Rows.Count, 1).End(xlUp).Row NextRow =...
  7. M

    Proper use of ALLSELECTED?

    I have the following measure which is returning 100% for every row. Voucher Spend as Pct of GL:= [Voucher Amt] / CALCULATE ( [Voucher Amt], ALLSELECTED ( Vouchers[Account] ) ) Voucher Amt:=SUM(Vouchers[Voucher Amount]) What I would like is for when I select certain accounts that the measure...
  8. sleek12

    Link Excel to (Multiple) Word documents

    <tbody> PV no payee date amount method of payment cheque no. MPESA ref; cash Account No of installment Prepared by Approved by 45 X ltd 30/11/2017 45000 Cheque 124 General expenses 4 Me You 46 XY Ltd 30/11/2017 55900 LQWERTY1 printing/stationary 1 You Me 47 XYZ ltd 30/11/2017 69000...
  9. Y

    count number of voucher per day

    I have sales data which I need to count the number of voucher for each day. Is there a formula to do so? Desired outcome: 4-5-0-3-2 for the five days. <tbody> DATE VOUCHER NO. 1-Oct-16 091 1-Oct-16 092 1-Oct-16 093 1-Oct-16 094 1-Oct-16 094 2-Oct-16 095 2-Oct-16 095 2-Oct-16...
  10. S

    Help with On errror Goto

    Hi everyone, My company is purchasing thousands of item via Paypal and I am building a macro to get data from checkout page. Normally I want to get the Funding type and Funding sources. So here is what I do: 1) Copy whole content of the checkout page (Ctrl C) 2) Paste all content into my...
  11. B

    Creating a voucher spreadsheet which generates word/pdf vouchers

    Hi, This is my first post on the forum so many thanks in advance for any help I might have. I work for a small activity centre and I'm looking for a way to enhance our gift voucher system and once I get my head around it potential use something similar to generate invoices which are a big...
  12. R

    MOS certification test

    Hello, I am going to be taking the MOS certification test for excel. Just curious if there is any one here who has taken the test (2010 test 77-882 (U.S.)) has any pointers for preparing for said test? Also, any suggestions on the best (and most affordable) way to purchace the test...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top