I have to color code several cells depending whether they are on
target or not.
Ex.
100% of Target = Green

How do I count the values in the rows showing in a column after applying a
filter to the worksheet? When I do something like =counta(b2:b450) I get 449
but this is not correct after using the filter.
Thanks,

Is there a way to get the page setup to apply to ALL the sheets in a
workbook. In other words to change the page setup for all the sheets in a
workbook so they are exactly the same or do I have to go through and do them
individually?

This is an attempt to provide an attendance form for completion at a
meeting. Currently a hard copy is printed, the record is made by pen
or pencil, a mark to show who is present,  and then I have to enter
the results into my spreadsheet.

Have HUNDREDS of phone nos in a column, display example 01456 123456
Some bright spark wants them re-formatted so the exchange is in brackets,
eg (01456) 123456.
Can anyone suggest a macro for this task, please?  Help would be much

I have a workbook with multiple sheets. In sheet1 there is the output of a
lab machine. It only consists of a column A that is filled with many rows.
Something like this:

Is there a way I can copy code across multiple worksheets without having to
open each worksheet code page and individually paste the code in.

My goal is to find the return type of a field. I have created a
customized right click menu. A user can right click and then choose
"conversion" option to convert the cell value, either from hours to
decimal or from decimal to hours. It is working fine.

For tracking department purchases using Purchase Orders, we had created a
Purchase Order Template and database using Excel 2000's Template Wizards.  
This worked out extremely well and was a fast, easy solution to keeping track
of individual department purchases from vendors.

This is the screen that comes up to correct a macro that does not work
anymore.
It is a macro that used to be able to print any previous week's data from a
seniors league that I run.

I can't figure out why this doesn't work, I keep getting circular references.
i have 3 workbooks. 1 is a summary linked to other 2 which are stored in a
different drive. The summary is I:\abc\etc\[summary.xls]sheet 1'!$d$6).
At the moment the cell inwhich this reference sits has ...

I have a large workbook with multiple sheets in it. With the help of many
macros, it automates certain tasks and leaves a finally workbook with a few
sheets (a kind of report).
I now need a way to remove all macros from this final workbook in one,

Can any one tell me.
Whem a User Edits an Excel file from centralised folder from server, one
file is created in that centralised folder on server and it is temp file. Why
it is created on the server, but not on the perticular users machine?

I've made a custom toolbar, EGI, which has two buttons on it. The
toolbar is attached to the workbook.
However, the workbook is only a template workbook, so many copies of
it will be made. When this happens the toolbar buttons relate to the

hi. I'm new in Excel. I have 2 questions.
1. In order to connect Excel with a MYSQL database, is it correct that I
have to install MYSQL ODBC driver into my Excel?
2. Is it possible to retrieve data directly from MYSQL database without