I have two worksheets arranged vertically so I can compare...I am trying to
scroll in one of them so the rows line up....how do I keep them both from
scrolling at the same time?

I created the following UDF in order to show the last saved date:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ThisWorkbook.Names.Add Name:="LastSaved", _
  RefersToR1C1:="=""" & _

I am copying data into excel where line feeds in the original data  are
represented by #. I want to do a find and replace all # with a new line (alt
+ enter) in a cell. How can I do this easily? Or if not easily, with a macro?

Example: Hlookup(a2,list,2).  I have a long list where I want the formula
change to 2 to 3 and so on.  Any suggestions?

Hi,
I'm looking for a way to make cell values change according to other cell
values.
for example,

Is it possible to lookup the minimum value in a set of numbers in a row and
then also list the column name for where the minimum answer value came from?

i have a spreadsheet with data:
document no. | product
I would like the Excel to compare cells a:a with cell f4 in sheet 2.
I need Excel to display all products where cell 'a' is the same as f4 in

Please consider opening up a new group for users of the super duper 2007.
where we could post items relating only to confusion over using the new 2007
and the "special" ribbons and what ever else..

In XL 2003
I'm trying to do a custom format on a sum of hours.
I want to display the sum of the hours as an equivalent in days and hours.
I have a guy working for me on a project.

Can you tell me how I can prevent the color in a highlighted cell from
printing?  I am creating a form and I have highlighted the cells which are
required to be completed by the people accessing the form.  But once they
have completed the highlighted boxes and are ready to print ...

I made a mistake and have already cancel the first mail, and I hope this
repost won't annoy people around here. If I did, I am sorry sorry.
Anyway, here is my question:
A1= Apple            B1 =12

How do I automatically insert the date the current file was last modified
into a cell in Excel?

i wont make a columne pf number if i add a new valew in a neww cell exicting
befor in this column one msg apear and the fot of this new cell chage to red
thaks

Here is my problem:
I would like to calculate a value X which gets in effect at a specific date
T with a probability P. From chosen date D, the probability P increases 0.05
per month till the date when P=1. From that date on the output is X (because

I need to convert dates into periods in an excel sheet.
For example 1/1/2007   -> 28/1/2007 = P1
                  29/1/2007 -> 25/2/2007 = P2
...until P13 (13 periods of 4 weeks). So a period does not necessarily