I have a workbook containing colleagues' daily hours worked on separat
sheets. I have then created a worksheet totalling how many hours pe
week each person has worked. How do I list the names in order of wh
has worked the most hours? I have the names in a row and the hours i

Alrighty, what we have here is 5 individuall reports that are created
by 5 different people here in our office.
The layout is identical on each of the 5 sheets, what I want though is
for there to be a master automatically filling out using all 5 sheets.

When using Subtotals, the buttons (1,2,3...) for easy access to row
level detail are not appearing.  I don't know why this is; wondering if
there is a setting turned off that I don't know about?  Has anyone
experienced this before?

I am about to establish the IT Logbook using excel. Does anyone offer a
sample for that?

I read the post for this question (8/8/2006) and Gord Dibben's answer works
great.
Original Question:
I need to format a column so that all cell force any text entry to uppercase.

I have an xls file that i want to export to CSV.
For some reason, I really need all the values to be surrounded by double
quotes even if they were numbers or a simple text with no spaces.
For example, currently, it is being saved as follows:

I start an app in vb with this code:
ActiveWorkbook.FollowHyperlink "C:\te.exe"
I always get a warning about hyperlinks that can be harmfull to
computer.

Assume I have a column of numbers, in a file named Source. (range is B2:B10).
These cells are linked to a column in a file named Destination(range is
E2:E10).
If I add a new row 5 to the source, is there a way I can get the previously

We import DBF (Dbase) files (produced by our ESRI mapping software)
into Excel 2003.  We're wondering why the resulting column widths are
almost all 254 once Excel opens the DBF file.  The data populating most
of these columns is generally under 10 characters/digits.

BARE WITH ME!!!!
How can I block only the cell that contains the Formula but make it s
they can keep inputting the daily numbers (I am sharing a spreadshee
that multiple people input daily numbers into. The thing is tha

When we open a DBF (Dbase) file created by our ESRI mapping software
the numeric fields, though they show as "numbers" under Excel's Format
Cell window, are not seen as numeric by the AutoSum (or any other
summing technique).  We get an error message that something's wrong

I am stuck for an answer here so any help would be greatly appreciated.
What I'm trying to do is group 2 columns together and create two
columns of that group much like using the columns feature in word. I
would also like to have these columns alphabetized. It really isn't

I have two spreadsheets.  In ss 1 there are names that are linked from ss 2.  
When I use ctrl+f to find the names, they are not found, even though I can
see that they are there. Any help is appreciated.

Want to enter column a1..a26 alphabetically. I'm sure I can do it using fill
on the edit dropdown, but can't seem to get it to work.
Any solutions out there?
Thanks in advance

Fellow Forum Members,
I have like 1400 rows of lotto winning history (small sample below). My
objective is to sort in ascending order each row. The problem is that
Excel 2003 is behaving oddly. I'm using Data-> Sort -> Options -> Sort