Thank you, Don
Got an immediate syntax error with your efforts.
I didn't mention that I'm using Excel 2003, VBA 2005, if that makes a
difference.

Is there a way to caluculate the hours between two dates and times while
excluding weekends and holidys?
Example:
Start - 8/24/2007 12:00pm

I'm not having much luck with doing a simple lookup.  For simplicity
sake, I have a table with three columns: name (A), duration (B), and
priority (C).  The table is sorted (and constantly resorted) by
priority.  I need to be able to look up duration values (in B) by

If a zip code ends with 4 zeros, I'd like to eliminate them and have the zip
code just be 5 numbers (or text). I'm not sure how to do this If/then
statement. Here's what I have (which doesn't work).
=IF(J2 Right(="0000"), Text("00000"), Text("00000/-####))

I have a spreadsheet where there is a lot of cells I want locked and
seven columns where Operators input data(one column/day)
I also run an autofilter as a macro when the sheet is opened to look
at non-blanks & also have a macro which clears out the Operator

I have a worksheet that contains rows of data.  I also have setup a 'form'
(in the general sense of the word) on another worksheet.  What I want to do
is take data from the selected row on the first worksheet and automatically
fill cells on that second worksheet (the 'form') with ...

Hi
I have a list of names and address in Excel 2007, some have which have been
modified/changed, ie addition of postcode, or streename spellings modified
etc. I cannot find a forumla or function which will enable

my column is long list with much same entries
i want to delte all duplicate entries in column
is easy way?
ty

Is there a way to update a job list automatically in one spreadsheet
each time I create a new spreadsheet for a job?
For example...
Everytime we start a new job, I create a spreadsheet (a template) to

Could someone give me the right formula please, I'm really stuck
I would need to have an Excel file work like this :
Page 1 - column 1 : empty at the moment, but as soon as I start writing in
it I would like to have automatically some data's on 2 other sheets of the

(This is a portion of my macro which loops through multiple sheets,
each with various rows of data to test)
Sub OpenSheet1()                                   [ Sheet has a Name]
'Opens Sheet 1 for clearing sold out items

I am running Excel 2003.  I need to import a .bas file as a button so
that it can be used on all worksheets/books.  I am aware of the visual
basic editor and importing a file, but what do I do from there.
Thank you in advance.

Problem: I have 2 spreadsheets. The first spreadsheet (SpreadsheetA)
is the master record of our inventory elements. The second spreadsheet
(SpreadsheetB) is a copy and paste of some of the elements in
SpreadsheetA but have been updated in some way. Is there a script of

I'd be very grateful if someone could help me with this.
I have a following table:
No, Company,Var1
12, ZXC, 6

Im an excel 2007 user and am having problems populating a combo box.
The code below runs a loop for every single row on the worksheets and adds
values from column G (Diagnosis) into the combo box where it is a text
value.