I have 2 columns.  Column 1 is text.  Column 2 says:  =IF(A1="","",Today()).
So if column 1 has data, column 2 gets today's date.
Question:  Is there a way to have column 2 update itself based on a change
to column 1.  My preference is that column 2 sets itself to the date an

Does anyone know of a way to do a Horizontal Sort?  I know it sounds odd
but i have a list of 972 rows where the information in each row needs to
be in alpha order. Column A is not to be part of the sort
SPLITRR    Rep1    Rep2    Rep3    Rep4

I have the following in a spreadsheet
     My Company 1 56346 56346 56346
     My Company 2 56850 56850 56850
     My Company 3 73130G 73130 73142

First off, I'm unsure whether or not linking is the correc
terminology.
I have a workbook that has many pages that have nearly the sam
information on every page. I don't like having to input the sam

i've been given the task of making a table of gps coordinates from 0
155metres where i have the Start and the End point and i use Fill >
linear Series to fill in the cells between. but is it possible to make
a shortcut or button on the toolbar for the series function.

I have a column of cells, each of which contains some text. I'd like t
be able to select only the cells which have less than two words in them
Is there a quick way for me to do this?
Thanks in advance for any suggestions

hi..
i have an excel sheet that i use validation to choose what i want to fill
cell with.
what i'd like to do is to autofill another cell based on what i pick from

As noted in a previous post, I'm having problems with text wrapping in
merged cells. While the response to correct the problem has 2 options:
1. Eliminate the merged cells - this is not currently an option.
2. Use an Embedded macro. While I like this approach, users tend to shy ...

Hi I have a cell with time in it - the cell is formatted to [hh]:mm what I
need to do is convert this so that instead of saying 32:15  to say 32.25 -
does anyone know how to do this - I would be so gratful!!
dawnyanne x

I have a bit of a problem I can't figure out although I think I migh
be missing something very obvious.
Basically I have this data for example formatted like this
A          B          C

Hi, can someone please help, I've been inputting values for row heights
by selecting 'Format>>Rows>>Height' and entering my required
measurement of 6.5mm, but when I select 'Format>>Rows>>Height' for a
second time to check if they're properly sized, instead of the 6.5mm I

hi guys..
can you please tell me how to convert 56:36 (addition of daily times in
column) to a decimal format which can be multiplied by hourly salary rate?

I have customised a file which removes toolbars, menus etc and some of the
sheets (accessed by macros linked to buttons) I want to keep private.
However, I have realised that the sheets can be accessed by using ctrl+page
up or page down. Is there a macro I can use to disable these ...

Hello, I am very novice in excel, and have encountered the following problem:
I have a file with a few tables (I use page breaks between 2 tables). The
first column of each table is a serial number column. So I want this column
to automatically start from number 1 (not including ...

Is there a way to trigger an excel macro anytime a file is saved?  
I've tried OnSave() and OnFileSave() with no luck, and google is
letting me down today....