Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-14-2016, 01:30 PM
lawnphysics lawnphysics is offline Sorting 1,000s of rows easily. Windows 10 Sorting 1,000s of rows easily. Office 2007
Novice
Sorting 1,000s of rows easily.
 
Join Date: Jan 2016
Posts: 2
lawnphysics is on a distinguished road
Thumbs up Sorting 1,000s of rows easily.

Hello, I need some help. I have 1,700 rows of data with 9 columns of data each.

I need to be able to sort the data in ascending order. I also want excel to keep the sort once saved and closed.

A data example is below:


Row 1: 2789 1003 3456 7867 100 1009 989 2003

Row 2: 7896 2098 7635 99 9897 61 897 4

Row 3.....

As an example column 2 would start with 989 and end in column 8 as 7867.



This goes on for 1700 rows. I have more data coming on Monday that will add another 2000+ rows. The only way I can figure out how to do it is manually. I have no idea how to use macros so if you give me a macro please explain to me how to use it. There is some coding out there for VBA that claims to do what I want it to do, but I have no idea how to insert it or use it. I have figured out how to get into the developer tab.



Thanks in Advance!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting 1,000s of rows easily. how to easily drop autotext into document Kendel Word 2 02-08-2015 09:50 AM
Two slides merge or view easily easy they are linked to each other Rajeev Saini PowerPoint 1 08-22-2014 06:56 AM
Sorting 1,000s of rows easily. Is there a function to easily and quickly highlight? Verbum Word 3 02-05-2013 10:09 AM
How to add 1,000s of email accounts nighttraindb Outlook 1 01-19-2012 10:14 AM
Sorting 1,000s of rows easily. Want boss to email me at two addresses--can I set this up easily? jessica19087 Outlook 1 08-26-2010 11:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft