hi community
can assist me to solve this ...
example:
       A                     B                    C          

I'm a CPA in industry, and have just taken a new position as Information
System Director for a large site contractor.  The accounting software my
company uses (Timberline - the preeminent construction accounting software in
the marketplace) has the capability of importing a comma ...

Usually, when I use the subtotal function under the Data menu, I am
able to group the subtotals. I am not able to do it in one file. Is
there a reason why? TIA
Greg

I just upgraded to MS Office 2007 but it uses Personal.XLSB files for the
personal work book instead of the Personal.XLS.  It loads my old Personal.XLS
file (which is over 1mb in size) but with complaints.  How can I make it work
in 2007 without having to export and import some ...

Does anyone out there know what time of the day is used for the XIRR
calculation?

Thanks for the quick answers and the Excel statement-help.  I know nothing
about Visual Basic or macro languages so those ideas went right over my head.
The IF statements worked great but I left out one requirement (constraint?)
in my earlier description of the data an my ...

I run a query in oracle and import the results into excel. What I'm
looking to do is create a column in excel with the avg of the
timestamps. For example:
CRAT_TSP    RESOL_DTE

I have a sub called SSave in a module called SLOCSave which I would
like to call in private sub Workbook_BeforeSave but I can't figure out
how.
HELP

I've seen 1000 posts on how to base a header on a cell value.  I need
to do the opposite.  That is to say, if the sheet name is "Dogs", I
need to put that value in a particular cell on a separate sheet.  This
can be done with vba or indwelling formula.

I just had a quick power outage, and now everytime I create a new
spreadsheet, Excel is automatically locking it so I can't go in and
change/add information. Can anyone help me figure out how to make it
stop?

Is there a way to copy a few cells worth of data into one cell without using
merge and center?
Thanks

I have a workbook with 14 worksheets in it and they all have the rows frozen
to display the columns.  When I save several of these workbooks to a
workspace, close, and then re-open the workbooks, all of the rows are
unfrozen.  Two questions:  How do I keep all rows frozen in all ...

I have a good one.  When I try to change print settings in Excel 2007 to
landscape, that's all I get is a reduced portrait print.  All settings are
changed to portrait and I am not having this issue when I try to print the
same document on any other computer with the same printer ...

In Excel 2007 I am trying to paste the column widths from another area. I
have done this many times with 2006 or earlier but with 2007 I try to go to
special paste and get a bunch of weird stuff (ie options to paste as a
bitmap, office excel 8.0 format, XML, etc) and not the ...

When I go to Open file in Word I can view a preview of the document or an
excel file but when i am in Excel and go to the open file dialogue  and want
to preview an excel file it does not show up.  I cannot figure out how to
turn on this same feature in Excel.  Thanks in advance ...