I have a spreadhseet that has 50 rows (steps) and 12 columns. Th
columns represent groupings while the row are an assigned steps in th
pay schedule. The first column A  (monthly pay) is column B (annua
salary) divided by 12. The same is true for the rest of the column

How do I  select only all subtotals in asheet and copy them into another
sheet .As there are many subtotals in a sheet , selecting subtotalsone by one
is not the easy way.

I've gotten some really great help here before and I'm hoping I'll be
able to get some again because I'm at wits end. I'm trying to get a
script to do text to rows. The following is how my spread sheet
looks...a few hundred rows of cells with data points separated by

I cannot make a paste link between 2 worksheets in excel 2003 if I use equal
sign (=). For example I have data is in Sheet1!A1, and I want to copy it to
Sheet2!B2 using equal sign. Everytime I type equal sign (=) in Sheet2!B2 and
point the sursor to Sheet1!A1 then result will be ...

I need to know if the GHK function will calculate the payment for a loan with
a constant interest rate

I need to work out how to concatenate an array of four strings skin to
the following (which does not work):
=CONCATENATE({"AAA";"BBB";"CCC";"DDD"})
="AAABBBCCCDDD"

I would like to convert hours and minutes to numbers. For example: 8:45 to 8.75

Annual Controbution $3000 Rate of Return 3%  Years of contribution 5 Years.
How do i calculate the amount saved

How do I calculate the averages of numbers in 2 sets of ranges... excluding
zero vaules?
Thanks

I am writing a conditional format formula and am getting the error:  "You may
not use references to other worksheets or workbooks for conditional
formatting"  But, I'm not referring to another worksheet in my formula.
Here's the Conditional Format formula in G19:

Hello friends: I have a small problem. I am a novide at Excel so please bear
with me. I ahve an excel worksheet with around 500 rows. Column X has all
number values (EX: 0.0245, 0.0354, 1000, 22 etc) and Colum Y has string
values (EX: "ab", "xy", "john" and "Q3"). The string ...

I have some formulas that refer to other workbooks.  I want the formula to
point to a different column, depending on the current month; e.g., in
January, the data will be in column E (and relative row references), in
February, the data will be in column F, and so on.

As a freelancer, a company sends me some spreadsheets.  I copy the data and
paste it into a new spreadsheet (to preserve the integrity of the original
data) then manipulate as appropriate.  
However, the date field is not copying and pasting correctly.  The original

I am trying to create a table that shows the previous 3 days worth of data
when the user inputs a date into a cell.  There are multiple rows with the
same date  but different times.  What is the easiest way to do this?  
(Example of the data sheet below.)

When I use to write, I had a text field on the top of excel. It is no longer
there. How do I get it back?