I have spreadsheet with thousands of records. I need to pull out all records
from first coloumn ending with "ic", and have spreadsheet sorted so those
records are on the top, or bottom, or create new spreadsheet with searched
records and delete them from the old one.

I have created an advanced filter using the first two columns which contain
"Yes" to copy to another location.  Now they would like me to take the
remaining items which would contain "No" or be blank" after the Yes items.  
Not sure how to update the criteria range.  Right now I ...

Example.  I have a number 12345678 I would like to add a zero to the
beginning like for it to reflect 012345678.  
I have a hugh list that I need to add a zero to the beginning of the number
list and I was wondering if there was away to perform this task without going

I'm trying to come up with a cashier balance sheet, fairly simple.  I
have everything done, except my manager would like me to add another
column for the cashier who cannot count down a till to a specific bank
amount.  This is compounded by his insistence that the balance sheet

Does anyone have an idea of how to accomplish this?

I want to do a lookup function but i don't know how to go by it.  I have 2
worksheets.  I need for Sheet1 to look for some records in Sheet2.  If a
record on sheet one finds a matching record on Sheet2, Then the record on
Sheet1 would be colored coded in Red.

We use excell to do all of our quotes and we have a formula we use every
time.  I am looking for a way to create a button or macro or some one key
option to fill in the following formula to a selected row, any suggestions?
Column

Let's assume we sell 4 products at the following costs: A - $1, B - $3, C -
$6, D - $10
If a customer spends over a certain gross level, the customer is entitled to
differing discounts.  The amount of discount varies depending on the item.

hey everyone. i'm doing an assignment for my computer class, and i'm
little stumped on one of the functions i need to create. i'm suppose
to be able to "automatically list all products that need to be ordere
when they fall below minimum limits". so i've tried a few things to n

I renamed all my digital and scanned photos but I have applications
that refers to the old names and directories.
I want to replace the old names & directories with the new names and
the new directories for all those jpg file .

I currently use the following formula to track employee earnings.
=SUMPRODUCT(('2004-JAN_05'!$C$2:$C$20000=$A43)*('2004-JAN_05'!$J$2:$J$20000>0)*'2004-JAN_05'!$J$2:$J$20000)
Where
Column C represents the emplyee

I have 2000
Can i use the button in forms toolbar and maneuver to different lpoints on a
sheet or even a workbook, if so how?

Thanks for your valuable input. However, to be blunt, I don't know what a
general module (insert module) is. Any further insight would be helpful.  You
appreciation regardless of further input.
Robin Smith

Is there any way to use the CONCATENATE function so that the text in the cell
holding the function will preserve the text colours of the cells which are
being concatenated? It seems to me that a cell which contains a formula
rather than a constant value cannot contain multiple ...

Is it possible to use wildcards in formulas?
I want to look at a cell and if it has the characters "-051" then I would
have the formula carry on to do something. the characters in the cell are
either ???????-051or #######-### the last three numbers being 00#