We would like to split a field which has sometimes 3,4,5, word in the field
the split should be as follows left word shall be copied in 1 cell, right
word in 1 cell ,all middle words together in  1 cell

I have a worksheet with a list in a column that gives choices ....
is it possible to put an if statement somewhere within the sheet to
make the choices picked in the column with the list change color?
In other words if say in

I have a MASTER summary worksheet with this layout
       07-Sep 14-Sep 21-Sep 28-Sep 05 - Oct Total
     No of late deliveries 36 40 20 10 9 115
     No of Drivers 18 32 11 11 4 76

I have a huge problem. I need to determine elapsed time in hours for
projects. The main problem I am having is that I do not know how to
set up a custom work week of 6am Monday - 6pm Friday.
I have a formula now, but it does not take into account the special

Can anyone tell me why the following routine colors and filters the first two
entries ("joint" and "hole") but the 3rd ("Fastener") just filters?  I'm
using excel 2003.
Sub joint()

I have a drop down list, and I type Z and clik on the arrow, it tells me that
its wrong.
I can use characters a-c but anything past that it does not accept it.  What
I am trying to do is select from a list by typing the First Letter.

Is it possible to switch back to the 2003 display with pull down menus in
lieu of all the new Icons? If so how?  I find the 2007 versions very
difficult to use.

I've made 3 macros on my computer and now I need to install these on a
couple of other computers.
I want to make a new toolbar, with 3 buttons that call these macro's.
Where can I find the default excel template? And how do I copy te macro's to

Hi Guys,
I want to write three (simple to you guys, i think) macros which will pull
out separately the following information.
1st Macro. I have a column which has a lot of random dates of when people

Is there a way to call the AutoFit function of Excel using one of the
macros defined in the XLCALL.h file?
I am trying to do this from inside a VC++ app.
Any help is welcome.

I have a spreadsheet that contains blocks of 9 rows, where the first 'cell'
in each row is made up of a number of merged cells.
I want to be able to copy and paste 9 single cell rows at a time from a
table in a Word document, in to the first 'cell' in 9 rows in my

I have a formula containing 6 of the following statements uysing
different cells
=IF(ISERROR(-'S:\Site Labour\Site Labour 2008\Reports\Variance Report\
[Labour Variance Report wk01.xls]Summary'!$W$55),0,-'S:\Site Labour

I have a link which i have to update the weeknumber (wk01,02etc) of on
a weekly basis i.e.
s:\sitelabour\reports2008\variances\wk01...
I want to make this as foolproof as possiuble for people to do. Is

I have the following problem with an excel file on a network share.
A first user open the file in rw. it lose then network connectivity.
After that, a second user (how asked to be informed when the file is
available) receive the message that the file is available and modify it.

Please let me have a sample code for referencing a sub-menu. I have
created sub-menus, but I now need to add items to them. This works for
first level menu items. How to make it work for 2nd or 3rd level menu
items?