Tagged Questions
1
vote
1answer
66 views
Office 2007: How to sort an Excel Table from within a Word macro
I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines:
Dim Oxl_Sheet As Object
Set Oxl_Sheet = ...
1
vote
1answer
41 views
Make Excel Row Height Stay when Sorted
I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature.
These cells are colored differently, but the height doesn't stick with the ...
5
votes
2answers
181 views
How do I expand columns of items in Excel so that each item is on its own line?
I have this:
-----A-----|-----B-----|-----C-----
1|cherry |apple |banana
2|kiwi |banana |cantaloupe
3|peach |grape |peach
4| |peach |watermelon
5| ...
1
vote
3answers
913 views
Advanced sorting in excel
I have a data in excel in the format:
Description Name Percent
Always A 52
Sometimes A 23
Usually A 25
...
0
votes
3answers
2k views
How do I line up two sets of data in Excel?
If I've got two sets of data, how can I line them up in Excel 2007?
For example, if one set of data has
Position Occurrences
8 3
11 1
17 ...
0
votes
2answers
284 views
Pull up Excel's Sort Dialog
I have to sort a protected sheet and need to perform the unprotect-sort-protect dance.
The problem is this way I'm duplicating (less than perfectly) Excel's own sorting functionality, with the ...
0
votes
1answer
2k views
Excel / VBscript: Need to sort columns with a header
I have a vbsctipt that opens an Excel(2007) document copies the used range from two sheets (minus the header on sheet 2) puts it all on 3rd sheet. I then need to sort that data using the header. I ...
4
votes
3answers
9k views
Fixing the first row as sortable title in Excel 2007
I know this is super easy, I just couldn't find it.
I'd like the first row in an excel document to be the "title" field. I want that:
Whenever I scroll down, this row will remain fixed
I can sort ...
