I am familiar with creating lists in excel, however, I need help on a
formatting issue.  Once I have more than one list, I can select an item from
one list without it automatically pulling an item in another list from the
same corresponding row.  Is there a way to get my lists to ...

I have a template excel file with two charts and one set of data.
Using ASP I am updating the dataset with the appropriate values.  That
works fine, however when the XLS file is opened, the chart does not
reflect the new values.  The only way I have found to update the chart

Im wondering if you could help me out as im trying all kind of trick
to make what i want it to work, i have tried =if(or(a1>b1,a1<b2)
"x","y") function, (b1=01/01/2005, b2= 31/12/2005)  it will work but i
no date has been input then it I

Hi, I am using the following formula to look up records on a worksheet
within the same workbook:
=INDEX(STUDY,MATCH(1,(Monday!B2=PART)*(Monday!C2=OPS),0))
STUDY, PART and OPS are named ranges.

From reading other threads, I learned how to reference or link a sourc
column to a destination column on a different sheet within a workbook
ie. =Sheet1!A:A
My question is, How do I link multiple source columns to a singl

I am wondering if someone can help me with a custom Macro using the
VLOOKUP logic.
I need to do something like:
VLOOKUP(lookup_value1,lookup_value2,table_array,col_index_num,range_lookup)

Hi Folks - I have data that looks like this:
     Identity Crimes Seminar - 04/13/2005 16 27 43 13 99
    16.16% 27.27% 43.43% 13.13% 100.00%
     Internal Affairs Course - 11/08/2004 3 15 6 1 25

I was wondering how do I go about linking the numbers in various excel
templates together so that a change in one template will be reflected in
another.
Ex.  I have a income statement template and a balance sheet template, if I

Im wondering if you could help me out as im trying all kind of trick
to make what i want it to work, i have tried =if(or(a1>b1,a1<b2)
"x","y") function, (b1=01/01/2005, b2= 31/12/2005)  it will work but i
no date has been input then it still show x

I am creating an attendance database for my company.
There are 19 different departments in the company and each manager
tallies
his/her own employee attendances.

can anyone help me to unprotect a protected cell in Excel sheet.
Thanks/Greg

I am new at this, I need to create 2 different types of randomness, one of
numbers and one of text selections.
#1 a range of numbers, i.e, 134-2807 that allows repeat of numbers with a
return of only 25 numbers. This random option is use daily so I need to be

I'm wondering if it's possible to invert data so that what is up at th
top will now be at the bottom and what is at the bottom will now be u
at the top.  This would be easy if I had only a few rows o
information, but I have hundreds.  Thanks in advance.

In the cels are only formules shown instate of their values.
I tried Ctrl ` but this only solves the problem for that moment.
How can I solve this problem?
Kees

Hi, I have a table similiar to this:
ColA                                         ColB
6/06/2006  9:58:16 AM    6/11/2006  2:33:25 PM
I want to calculate the difference between ColA and ColB, excluding the