I have a worksheet with header in first cell A1 to K1.
In columnJ sarting from J1, I have some USER-IDs.
I have a defined list of users as SUserin worksheet Temp.
Based on the SUser, I want to remove all other rows, leaving behind

I know that I can rename a workbook that I am editing using Save As.
Is there any way to rename it without saving it?
Ideally, a "command".  Alternatively, a macro.
After saving a workbook (ctrl-S), I want to "play" with it without

Is there any way we can change the default cell reference when forumlae is
copied to the susequent cells.
Below is the example where i need to roll up the week day information to the
weekly. So, if need to obtain week-1 count i used countif(<week-1 range

When I use the DOS Prompt screen, it automatically shows a particular
directory.
I would like preset the directory that come up automatically.
As it stands right now, it does not come up with the directory I want.

I use a lot of colors in my worksheet, but when it comes to print I do not
really
need them at all  times.
Q : Is there a setting to print a worksheet that have colors but

Em tempos gravei um ficheiro no excel, e agora preciso imenso de aceder ao
referido ficheiro e não me lembro qual a palavra-passe que atribuí para o
abrir.
Será que alguém me poderá ajudar?

   I'm trying to achieve the following but unsure how to go about it.
I have Excel 2007 and Access 2007.
  I have a spreadsheet (A) with a list of plants. One column is a
"pick list". What I want to do is: if I put a non-zero figure in the

Excel 2003 SP3
I need to take an existing spreadsheet that has six columns and selectively
"insert" a new column in a couple of rows.  Once the single new column has
been inserted I'd like to resize this new "A" and put an * in it, color it

Is it possible to connect a Microsoft Access table to manage it directly
from Excel
to get the data synchronized both in Excel and in Access?
Thanks, Emiliano

Hello     my code is
Private Sub Worksheet_Change(ByVal Target As Range)
   If (Range("F365") = "No") Then
        myArr = Array("12", "15", "17","33","45","89")

I am doing my taxes and need to find a way to convert my broker's 1099B
(stocks transactions during the year) from a text pdf form or Word
document into an excel format.  Is there a way to do this?
I can receive my 1099B data from my broker as a pdf or as a printed

Can I do multiple condition in Excel?  How? Please tell me an example.  Also
please let me know can I do that in IIF condition?  Would appreciate your
response.

Hope someone can help me here:
let's say I have table like the following with different situations of
'Target' and 'Result' and I want to calculate deviation from 'Target'
in an Excel sheet:

This is a re-post from earlier.  My LINKS have broken and now reverted back
to Sheet #1 instead of Sheet #79
Here is the original post;
The code below works for one Workbook.  Problem is, I copied the "Standings"

A2= $29    
B2=$70
B4= should be green
If (B2)is greater than (A2) "highlight" (B4) green.