I have an Excel Workbook that is Shared and it uses the Vlookup function to
look up values in another Excel Workbook. Both files are stored in a Network
drive and I use \\server_name\shared_folder\filename.xls format to reference
the file in the first Workbook.

I have a table in access with the fields Date and Enquirytype.  There are 5
enquiry types.  I require a report that gives monthwise the number of each
enquiry type.  for eg. in oct 06, how many records have A type enquiry.  Say
the columns with enquiry type and the rows being the ...

What is the VB command for a button that has to go to the top, what
ever the colom you are.
Bart

I'm using the following formula(s) to count how man instances of a
certain number I have in three different columns.  The problem is that
it is working for most of the numbers but not for others.  Only the
numbers 1-12 are in the cells.

I have a conditional format that turns every cell on an even row light blue
using a conditional format of Formula is: "=MOD(ROW(),2)=0".
My problem is that I want to retain the light blue colour and format the
font to Bold Italics where the value is less than -100000 and greater ...

Is there a way to keep Excel from reiterating your code over and over? I
know I can change it under options, but when I send the spreadsheet to
someone else they may not have the same options set as I do. Can this be
accomplished in a VB code?

The answers to my previous post worked wonderful with the exception of this
specific formula.
my original code, works but gives divide by zero error when empty.
=SUMPRODUCT(B2:B65536,C2:C65536)/SUM(C2:C65536)

To fill in a value V, with the restriction that the stock number
(10-40)  should have the same value as in Sheets B, C, ...,  I use in a
cell right of the stock numbers in Sheet A the folllowing code:
=IF(ISNUMBER(MATCH(C7,'SheetB'!A:A,0)),'SheetB'!C1,IF(ISNUMBER(MATCH

Is there a way for change the default font in excel? Thanks in advance!
Aiandas

Looking at all the posts about MATCH, it seems that its a triggy
feature. Mines results in an error, appearently because of its
limitations.
=IF(ISNUMBER(MATCH(C7,'Sheet C'!E:E,0)

Sorry to bother you. I just couldn't find a way to solve it. Here is the
scenario,
         A        B
1        2         3

Just a quick question, I'm using M/S Exel 2003 and would like to know if it's
possible to make a 3 column drop down list that depends on the list before,
i.e
Column A1 would be “Size”                Just a normal list (covering A-Z)

I do have two sheets SheetA and SheetB
SheetA
111    100
222    200

Hi guys/girls,
I have the worst time trying to figure out how to write a macro for an
schedule i need for my work.What i need is a macro that can figure out
that if Joh starts his work at anytime before 4PM copy his work hrs to

Is there any way to put something in your formula to get the error #DIV/0!
to be ignored? I know that you can change the iterations on the calculation
tab under options. But the formula that I'm using is correct and what I
want. Just wondering if I can suppress the warning to the ...