Results 1 to 15 of 15

automate routine sorting activity using macro

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    52

    automate routine sorting activity using macro

    Hi all,

    I am working on a project where I am required to audit invoices based on certain parameters.
    I have listed the parameters on the attached spreadsheet.

    I get a voluminous data running to several thousands of line per day and I need to choose only those lines that satisfy the given parameter.

    my parameters are as below
    1. all telecom invoices require audit (100%)
    2. All invoices whose value is less than zero require 100% audit
    3. all invoices with payment method as Wire - Direct require 100% audit
    4. all invoices whose invoice amount is greater than 30000 require audit
    5. All duplicate URN need 100% audit (sorting based on URN column on result sheet.

    I tried to record this macro but not able get the desired output.

    Could someone please help me with this?

    Regards,
    Kiran
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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