Hello,

I am writing a program that will take a spreadsheet full of data and will then autopopulate a general journal ledger with the information. I am stuck at a part where I have data from cells (5, 2) to (35, 2) and from cells (46, 2) to (75, 2) [I am using R1C1 format] and I want to be able to select the two sets of data and sort them into ascending order (they are all numbers.) However, I want them to all stay in the two ranges after being sorted. Is this possible? Or do I need to sort them, and then move them back to the two ranges? I have no code on this as I am completely stuck, so any help would be greatly appreciated.