+ Reply to Thread
Results 1 to 6 of 6

How to create monthly bills automatically?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-10-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: How to create monthly bills automatically?

    Alright! but I have seen a template named "SALES INVOICE TRACKER". They used a very complicated formulas in it.

    It says "=IFERROR(INDEX(InvoiceDetails,SMALL(IF(InvoiceDetails[Invoice '#]=rngInvoice,ROW(InvoiceDetails)-ROW(InvoiceDetails[#Headers])), ROW(1:1)), MATCH($C$13, InvoiceDetails[#Headers], 0)),"")"

    If you can explain it to me? I might get what i want.

    Thanks

    P.S. I'm not familiar with Microsoft Access or you can say that I'm afraid of it :/
    Last edited by nabeel.mct; 08-10-2013 at 08:36 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 03-01-2013, 02:34 AM
  2. Monthly reports from Quarterly Bills
    By naigy in forum Excel General
    Replies: 1
    Last Post: 05-31-2011, 01:22 PM
  3. Replies: 14
    Last Post: 03-25-2011, 08:31 AM
  4. Automatically create monthly totals from daily data
    By mundo in forum Excel General
    Replies: 6
    Last Post: 01-02-2009, 05:33 AM
  5. How do I make a chart that will automatically calculate my bills .
    By melissto in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-20-2005, 04:06 AM

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