Please give your suggestions for my above query.
Thanks
Murthy

Any ideas how to get this format of numbers into 1 column?
0     25    50    75    100                          I would like this:     0
125 150  175  200  225                                                      
25

worksheet A
cell F name is called product code
cell F2 is Q921
cell F3 is Q5201

How do I autofill the following formula =INDEX('Zip
Data'!A1:H41576,MATCH(E2,'Zip Data'!A1:A41576,0),5)?
I have used the $ signs and for some reason it doesn't return the correct
match.

I'm creating a read only file on a network drive but I don't want users to be
able to copy or print this file.

I have two cells that contain functions that return numbers.  The cells are
formatted as numbers, and display as numbers.  When I try to sum these two
cells the answer is wrong.  The SUM cell is also formatted as a number.  
Embarrassed to say I've been programming for 40 years ...

I would appreciate any help from an Excel guru out there that can help
me automatically convert a cell with a day:hours:minutes:seconds format
to seconds.  So for example, 0:00:04:44 should be converted to 284.
Any ideas?  Thanks in advance.

I have a spreadsheet with links to a couple of other sheets. However, how
can I find out which cells are linking to other sheets if I've forgotten? It
is a huge sheet, and when I open it and click "update" it complains about
one of the linked sheets being missing - I need to ...

To revise a completed Excel sheet whose entry bar disappears, how can one
edit by restoring the entry bar?

Am using LOOKUP formula to return values and it all seems to work fine.
=LOOKUP(B19,'[andrew v2.xls]Sheet1'!$B$5:$B$28,'[andrew
v2.xls]Sheet1'!$C$5:$C$28)
However, when dragging and copying the formula, if the Lookup_value is not

My company uses excel to budget our labor cost.  I want to have the same cell
in multiple sheets (Sheet 1 J4, Sheet 2 J4, through Sheet 12 J4) to add
together in Sheet 12  J4.  What are the steps that I need to take in order
for the cells to add?

I have a spreadsheet with three columns and numerous rows.  If Column B meets
a certain criteria, and Column C meets a certain criteria, I'd like the
reference number in Column A to be inputted into a different part of the
spreadsheet.  How do I do this?

Is there anyway to change the way that the Database function analyzes the
Criteria range?
Default is (according to
http://office.microsoft.com/en-us/assistance/HA012186941033.aspx#Example3):

I have 3 columns of dates (A1, B1, C1).  
Several different scenarios:
1.   If A1 is blank, but B1 & C1 are populated, I want to put the result in
D1.

I'm looking to perform what I believe is a "Match" function but not exactly
sure how to achieve it: I am trying to Return receipts of products by
location. My sheet is set-up like this
Location 1 = A8