Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to arrange spreadsheet by either name or date?
The subject line may not be clear, but what I want to know is if there's an
option in Excel that aloows me to choose the arrangment of my spreadsheet (either numerically or alphabetically). Can someone plese help me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to arrange spreadsheet by either name or date?
Yes. Look in HELP for Data/Sort ---GJC -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=529436 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to arrange spreadsheet by either name or date?
I guess I should have told you, when you get the Sort dialogue box, Choose Options and Select Left to Right rather than Top to Bottom. ---GJC -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=529436 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to arrange spreadsheet by either name or date?
Okay, Sorry, ignore the last post (unless you want to sort columns vs rows), I was just reading the another post & got my responses mixed up.... -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=529436 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to arrange spreadsheet by either name or date?
You need a VBA to sort your sheets alphabetically.
Sub SortALLSheets() 'sort sheets within a workbook in Excel 7 -- Bill Manville 'modified to sort all sheets instead of just worksheets Dim iSheet As Integer, iBefore As Integer For iSheet = 1 To ActiveWorkbook.Sheets.Count Sheets(iSheet).Visible = True For iBefore = 1 To iSheet - 1 If UCase(Sheets(iBefore).Name) UCase(Sheets(iSheet).Name) Then ActiveWorkbook.Sheets(iSheet).Move Befo=ActiveWorkbook.Sheets(iBefore) Exit For End If Next iBefore Next iSheet End Sub HTH Gilles "Kate" wrote in message ... The subject line may not be clear, but what I want to know is if there's an option in Excel that aloows me to choose the arrangment of my spreadsheet (either numerically or alphabetically). Can someone plese help me. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to arrange spreadsheet by either name or date?
Sorry, you need to cut and paste from SUB to END SUB in your VBA editor: ALT
+ F11 and insert module in PERSONAL.XLS, that way the program shall be available for all Excel files Gilles "Kate" wrote in message ... The subject line may not be clear, but what I want to know is if there's an option in Excel that aloows me to choose the arrangment of my spreadsheet (either numerically or alphabetically). Can someone plese help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up a 'moveable date' on a project spreadsheet? | Excel Discussion (Misc queries) | |||
Date stamp spreadsheet in excel to remind me of completion date | Excel Worksheet Functions | |||
Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
How do I display the last saved date in an EXCEL spreadsheet? | Excel Discussion (Misc queries) | |||
Automatic date change when spreadsheet changes | Excel Worksheet Functions |