Results 1 to 10 of 11

Thread: Finding Credit and Debit Data and Creating Pivot

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-23-2012, 04:17 PM #1
    Prabhu
    Prabhu is offline
    Member
    Join Date
    Aug 2011
    Posts
    54
    Rep Power
    14

    Finding Credit and Debit Data and Creating Pivot

    Hi Friends,


    I have attached receivable statement. From that sheet I need to create two sheets once as Credit and debits.

    Sheet "Credit" contains negate transaction (In Column "H") and sheet "Debit" contains positive transactions.

    Vendor wise I need to create Pivot table for both sheet(Credit and Debit) as per the sheet attached.

    Kindly help to create VBA code for the same.

    Regards,

    Prabhu
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. finding the number of occurrence
    By zzzqinzzz in forum Excel Help
    Replies: 2
    Last Post: 12-13-2012, 10:24 AM
  2. Group Pivot Data Based On Row Values In One Column
    By mrmmickle1 in forum Excel Help
    Replies: 10
    Last Post: 10-09-2012, 11:46 PM
  3. Creating Chart (Line) using Array data, not ranges.
    By Junoon in forum Excel Help
    Replies: 3
    Last Post: 05-14-2012, 11:30 AM
  4. Finding highest value in array
    By Rasm in forum Excel Help
    Replies: 15
    Last Post: 06-24-2011, 03:59 AM
  5. Finding Last Used Row or Column In Excel Sheet
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-14-2011, 03:17 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
  •  

Forum Rules