My worksheets have dozens of columns, each with up to a few thousand rows.  
Both enumber of columns and rows varies from one data set tp another.
I'd like to have a macro that would delete the last value in each column,
but only if it's less than 90% of the penultimate value in ...

Hi I'm having problems with a workbook with links to other workbooks. I've
checked that links are set-up to update automatically in excel and that
calculations are set to auto under options.
In order for links to work the source spreadsheets have to be opened and on

I have a File with Pivot Table.   What I want to do is the selection I have
created, I want to Copy the created sheet with the selected data to a New
File without all the data going with that file.    Is this at all possible
eg - I want to send each person the data that is ...

my problem is that i want to copy(link) single character into multicell from
a string.
from single cell --> 3678498 (in A1)
to these multicell --> | 3 | 6 | 7 | 8 | 4 | 9 | 8 |(A2, B2, C2, D2, E2, F2

Is there any way to use the MATCH() function to grab only values that
are less than the lookup value (instead of <=)? I've considered using
an IF() with ISNA(MATCH(**,**,0)) to setup separate conditions, but
I'm afraid of what it will to do my already long processing time.

Don helped me with a formula I was struggling with, and the two he developed
work PERFECTLY:
=AVERAGE(IF('Quarter 1 Data'!$G$4:$G$500="Allen",'Quarter 1
Data'!$C$4:$C$500))

Hello, is there a way to grant access for multiple people into one
spreadsheet located on a shared drive?  So that a group of people could go in
and work on it at the same time and save changes?

I was working on an excel 2003 spreadsheet, in Windows XP, and I had
to check an email for billing purposes.  In the email there was a
another spreadsheet that I opened.  I printed it and then closed it.
It asked me if I wanted to save the changes and I said no because that

I'm using data validation on one cell, say C19.  Is there a pre-defined event
that we can use so that when there is a change on this specific cell it will
prompt the user for a password?
I'm new, I already have this code: (but it's not working)

I have daily data like so:
Date    Volume
20070103    25
20070103    25

i have a very long column in Excel that has the following type of
information in each cell:
Bosch|Dish|Dishwasher|Bosch Dishwasher
I'm trying to use FIND, LEFT, LEN, RIGHT, and IF to extract the word

We are using Office XP Standard. We used to be able to open two separate
workbooks, opened separately from a folder on our file server, then copy one
formula to the other.  Now when we try to do it we can't even use "paste
special" to paste the saved formula.  We get a menu that ...

I had the understanding the cells with validation lists could not be
autofilled.  For example if I have a list of three people
Tim
Jake

Perhaps if I start over. If L <>5, and either or not text in B,
then either "alert" or "OK" in K
First row, nothing in B , D thru J adds up to zero , therefor need "OK" in K
2nd row, nothing in B  , D thru J adds up to 7, therefore need "Alert" in K

I have two worksheets I am working on.  On one worksheet I have the same
project number listed multiple times with $ amounts listed by months.  On the
other worksheet  I need to sum the $ amounts by project number and by month.
How can I do this with reliable accuracy?