OT - Excel question

what version of Excel are you using?

Excel 2002

Karen, Queen of Squishies

2002 -- does that mean MAC? I'm working on an answer -- but I'm a PC person -- so we'll have to see if it will work in MAC world. Does Mac Excel use VB?

Oh, no, sorry. I have Windows XP Office, with Excel 2002.

Do you use Yahoo IM? That would make things like this a little easier. Just curious.

Karen, Queen of Squishies

I found this answer:

You can use Alt - F11 to open the VBEditor. I am NOT very familiar with this but am contacting a friend for help...

Yes, you explained it very well! I have 34+ worksheets though, and didn't really want to do it manually every month. I'd like to be able to sort, print, and put back where they were. My envelopes print alphabetically, and my invoices print chronologically. It's doable right now, but when there gets to be upwards of 50 invoices, it sure would make the sorting and stuffing of the envelopes a lot easier!

Karen, Queen of Squishies

Wow, very impressive! I don't understand a word of it! LOL

Karen, Queen of Squishies

The only way that I know is to manually sort them. You can left click on the worksheet and then place the worksheets alphabetically. A blank page will show when you place the mouse cursor over the worksheet. Keep the left click down until the worksheet has moved. I hope I explained this right! Regards Jennifer Edmonton, Alberta

There's a Data action dropdown on the action bar. In the Data dropdown there is a Sort... action. When this is selected it launches a pop-up window that asks you which column you would like to sort first on and whether it should sort Ascending or Descending. Lastly, if you utilize the first row as a header row, then select that option.

There are other "Advanced" options you can select in the Options page, but these are things like Days of week or Months and sort left - right instead of top - bottom.

Found it. That seems to apply only to the current page, and sorts the columns, etc. I'm trying to find a way to sort the pages themselves and make them arrange themselves in alphabetical order.

I don't think it can be done, actually. But thank you!

Karen, Queen of Squishies

Make a new column and put the page's alphabetical label in each row. Sort the rows by the value in that column. Remove or hide the new column when you're done.

(I think. That's generic advice that will do the same thing with any spreadsheet; maybe I'm missing some details of the problem).

==== j a c k at c a m p i n . m e . u k === ==== Jack Campin, 11 Third St, Newtongrange EH22 4PU, Scotland == mob 07800 739 557 CD-ROMs and free stuff: Scottish music, food intolerance, and Mac logic fonts

I've used a free Excel add-in called ASAP Utilities for years. It really is a nice addition to Excel. It does what you want and so much more. Here's the website -

If you have second thoughts about downloading something recommended by a stranger, you can download it from cnet's download site, download.com. PC Magazine reviewed it - If you google it, you'll find that it's a very popular program. NAYY Elaine

It can be done -- but you need to do it via Visual Basic Script. (and I am not a VB knowledgeable person).

Using the website I gave you earlier as the VB data to copy and paste -- here is the additional information I received: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~```` If you're not familiar with VBA and macros, see David McRitchie's site for more on "getting started".

or Ron de De Bruin's site on where to store macros.

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module.

Copy the macro from Chip's site.

Paste the code into the created module.

Save the workbook and hit ALT + Q to return to your workbook.

Run or edit the macro by going to Tool>Macro>Macros.

You can also assign this macro to a button or a shortcut key combo.

I'm still trying to understand how to make this work... but no luck yet...

Yes, I think you might be. Basically, I don't want to sort columns. I have

34 spreadsheets in one workbook. I want to sort the spreadsheets. But I thank you for trying to help me. And nice cats, btw!

Karen, Queen of Squishies

Karen, Do you have a version of Microsoft Access? You can import all of your excel sheets into an access database. You can then create queries and/ or macros to make it do what you need to. I've found that Access is MUCH more powerful than Excel and once you get used to the few differences, can make life much easier.

Kim in NJ

........ if I can just get them sorted........ lol

Karen, Queen of Squishies

Too bad you have to put them back as they were. Once the worksheets are sorted they will remain alphabetical. Regards Jennifer

>

The only reference I could see to 'sorting' was sorting within the page. Did I overlook somewhere that it will sort the pages within the workbook? Thanks, Elaine.

Karen, Queen of Squishies

When you say you want to sort pages within the workbook, I assume you're taking about sorting worksheets. Here's a direct link to the page that talks about sorting -

Sort all sheets. You can specify to sort the sheets alphanumeric (text), numerically (numbers) or by their tab-color. You can also specify to sort the sheets ascending (A-Z) or descending (Z-A).

Elaine