I have an excel file with many spreadsheets (tabs).  I need to take certain
totals from each spreadsheet and put them into a summary spreadsheet.  My
question is:  Is there a quicker way to do this than typing = and then going
to the cell on the appropriate spreadsheet and ...

I have a workbook with multiple sheets that I would like to Hide before
close.  I am using a macro attached to a "Quit" button, but it does not
work.
I also have a Sub in ThisWorkbook, but I can't seem to call it

I would like to see the unique values from column A, where Column B is
a max() for that value in A.  For example, in Column A there are
several 1's, I would like to see the max of column B, where column A is
a 1, and the same thing repeated for all the other unique values in

I get the error "Could not add the table
'\\lth01pc354\c$\Logs\History\TEST.CSV)' when running this subquery on an
external data source:
SELECT BEMIS_BAGGER_RATE AS 'RATE', (SELECT Avg(Val(BEMIS_BAGGER_RATE)) FROM

I need to insert a new row into a workbook where a character in Column "A" =
"D" and then copy the row which is two rows above into the new inserted row.
I can insert the row ok with the following code;
Sub Add_Rows()

I would like to extract the fraction part out of a number. For example:
1.5 -> 0.5
23.45 -> 0.45
25 -> 0

Our NPO is creating a reimbursement chart in Excel. We're trying to make it
so that if employees do not fill in one particular column entitled
"Projects," they will get an error or will be unable to have a final sum
filled in.

Yes, I've checked the scroll lock...it is turned off.  Keys worked for
the user until he added a toolbar and hit reset.  From that time on the
arrow keys did not move from cell to cell.

Where can I find info on admin functions for Excell?

I'm trying to change symbols to numberic values & not finding any answers.

Need help with a formula..
Let's say I have "12/31/2000" in Sheet 1, Cell A1 and I need to see if
this date is in a table in Sheet 2 and if it is it will return a value
of "1" and if not it returns a value of "2"

Hi.
My PC is in Italian language. In a file of Excel I need to get the dates in
English.
I have set the date format as follows:  [$-409]gggg, mmmm gg, aaaa

After searching these groups, I don't think I've found a solution to
the following issue: When data is output in excel format from the
source application, it shifts all rows to the left rather than insert a
space for a null result. The result looks something like this:

Hi, hope someone can help. I am trying to get a value in dollars in one cell
dependant on another cell being one of two letters. If a particular letter
appears then the cell will give the result of a third cell multiplied by 9%,
if it is a different letter it will give 9% of ...

I have a worksheet with some cells in a column blank.  Where that happens I
want to replace the blank with whatever is in the cell directly above, at
least within a range.  I've looked around here and in Excel Programming and
there seems to be an idea to put the formula "=R[-1]C" ...