Sorting Data

howard

Well-known Member
Joined
Jun 26, 2006
Messages
6,046
Office Version
  1. 2021
Platform
  1. Windows
I have a workfile that I need to sort by Date and Control Number (Ctl)

The Problem that I am faced with, is that I may have a date 25/04/2007 with Control Number 8045 for say 1000.00. The customer may only pay on say 01/05/2007 on control number 8045.

I would like VBA code that will sort the data by Date, but also group all the control numbers together. In this example it will be as follows


Date Control Number Amount

25/04/2007 8045 1000.00
01/05/2007 8045 -800.00

I have attached sample file. In the sample file the CTL 8322 & 8722 must be grouped together when the data is sorted by date as they are not unique. The balance of the unique records must be sorted by date in ascending order

Your assistance will be most appreciated

Howard
Cash Sales.xls
ABCDEFG
4RefNoJrnDateDateCtlTransamt.balanceAgeing
5A0001SVC15/06/0715/06/200783221443.181443.1841
6A0002SVC09/07/0709/07/20078690650.94650.9417
7A0003SVC10/07/0710/07/200787226148.84 
8A0004REC11/07/0711/07/20078711-188.1-188.115
9A0005GEN16/07/0716/07/20078322-1080 
10A0006SVC17/07/0717/07/200788401449.441449.449
11A0007SVC18/07/0718/07/200788695229.12-403.818
12A0008SVC18/07/0718/07/20078851278.33278.338
13A0009REC18/07/0718/07/20078722-15004648.848
Sheet1
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Anthony47

Well-known Member
Joined
Mar 29, 2006
Messages
2,274
I seem that you should sort by Ctl / Date (in this order). Is my interpretation correct?

Bye?
 

howard

Well-known Member
Joined
Jun 26, 2006
Messages
6,046
Office Version
  1. 2021
Platform
  1. Windows
Hi Anthony

Your interpretation is correct.

Regards

Howard
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,565
Messages
5,765,140
Members
425,263
Latest member
alcat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top