Results 1 to 9 of 9

Sort by Stock Name then list by Oppsite Transactions

Threaded View

SMJE Sort by Stock Name then list... 01-15-2011, 01:40 PM
broro183 Re: Sort by Stock Name then... 01-15-2011, 08:40 PM
SMJE Re: Sort by Stock Name then... 01-17-2011, 04:55 PM
MarvinP Re: Sort by Stock Name then... 01-15-2011, 09:00 PM
broro183 Re: Sort by Stock Name then... 01-15-2011, 10:42 PM
Leith Ross Re: Sort by Stock Name then... 01-16-2011, 05:14 AM
broro183 Re: Sort by Stock Name then... 01-18-2011, 06:39 PM
MarvinP Re: Sort by Stock Name then... 01-18-2011, 07:25 PM
broro183 Re: Sort by Stock Name then... 01-19-2011, 06:57 PM
  1. #1
    Registered User
    Join Date
    01-15-2011
    Location
    Kent, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Sort by Stock Name then list by Oppsite Transactions

    I need to create a macro which will sort data, first by Stock Name. Then, for each Stock Name, rows which are opposite transactions to be listed first. Opposite transactions are those which have the same stock name, same quantity but one is delivery and the other is receipt.

    So, in the attached spreadsheet, the data on the left should be sorted to show the data on the right.

    Can any please help me?
    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