I have two similar macros that usually takes 45 seconds to run however one of
them takes 4 minutes to run with the only difference is the filtering from
one group to another. I have narrowed it down to the filtering portion of the
macro that takes so long, can anyone tell me why ...

I am a student studying RE law and have a lot of terms to learn.  I would
like to make an alphebetic list of terms from multiple textbooks into a
spreadsheet and want to command it to list them in alphabetic order for me.  
How do i do this?

Sometimes - especially when I copy/paste from Access - dates look like dates,
I can format the cells as dates, but they're not *really* dates.  For
instance, if I format the cell as a number, I should get the serial date.  
Or, if I change the date format from mm/dd/yy to m/d/yyyy ...

Is there a way to create a form where you enter data in a parent field and it
populates several "children" forms? For example, paperwork in clinical
setting. Child forms have individual client info. Parent form is where data
applicable to all can be entered and populated in ...

I have a workbook with 75 worksheets (tabs) and would like the value in field
D1 to be the name of the tab? Is this possible and how would I do this?
Please help. Thanks.

Cell format issue:
There are times when I run into an issue where
I am typing in formulas and somewhere along the way the format changes.
Example:

I want to show how many sheets I have in a workbook using a formula. The
number changes everyday. What do I use, or can I even do this?

I've been trying to sort rows of data in Excel2003 that includes 3 colmns. I
want to sort the rows by the data in the first column. I click on a cell in
the first column and then click sort in ascending order. The bottom row is
moved to the top of the list, but the rest of the ...

I have a workbook which is created from another workbook - basically a
copy and paste job into a pre-existing blank workbook, which contains
some VBA code and a couple of picture logos which when clicked run the
macros.

How can I change a name that is in a "John Smith" format to "Smith, John"?
Thanks in advance for your help.

Have a single, subordinate spreadsheet (Summary) linked to many independent
spreadsheets (Team Member Status Reports). In the Summary (or subordinate)
spreadsheet there are many references to cell values in the Independent
spreadsheets such as:

Hi:  This is giving me a headache.  I have time formatted as hh:mm:ss, the
data contains entries with minutes and seconds and just seconds.  I need to
multiply the number of seconds of each call by the number of calls to arrive
at number of seconds then take the number of seconds ...

Hi,
I am using a vlookup to extract comments relating to particular ref. no's
from a seperate worksheet.
The vlookup has been created and works for one cell.

I have raw data that I want to pull into my main sheet.  It looks like the
following.
What is best formula to us so it auto picks the proper column in rawdata?  
Thanks.

I have a date field with dates ranging from the 1850s through to 1930 with
dd/mm/yyyy
I know about xdate - to handle dates before 1900
Is it possible to sort on this field successfully ?