I am trying to combine three separate indexes (authors in the first
column, and volume & page number/s in the following columns) and really
only have Word and Excel 2000 to work with. The data is all as text,
because otherwise it messes up the number format.

I want to select cells A1:A5:A9:A13:A17:A21 etc. etc. A4021: A4025
So, I want to select A1 + 4.
I would be very thankful if someone could help me.
Ragards,

I recently purchased a new system and running Windows XP Pro. All
attachments for Excel which come over in my email are identified as a *.zma
file.
Anybody know how to correct this to support a *.xls file?

When you record a new macro it asks you what Ctrl key you want to access it
with.  If you Edit the Properties of a Macro it asks you what Ctrl-Shift key
you want to use to access a macro.  How can you have more control over this
to assign the proper key to a macro?  Thanks.

i have a list of tex/numbers and i need excel to delete and duplicates i will
have in the worksheet.
Im new so i might need detailled instructions

Is there any way for me to run an IF function that meets the following
criteria:
If column C INCLUDES the word "German", then return "German" in this
cell.

I have a document of several columns and rows. I need to have column B,
D, E and F grouped somehow for each row so that if we delete the info
in column B, column D,E,F automatically delete. Does anyone know how to
do this?

How can I dynamically change the print area without using a VB macro.
The rows of data in the spreedsheet A1:E1200 varies each month.
I.E.  month 1 there is data in A1:E800,  month 2 there is data in
A1:E1100, Etc.

Does any body know a formula that calculates the point where two exponential
lines cross in the future.
Thanks

Dear Group,
I need to create a form for entering information from the original paper
version submitted by staff following an incident.

I want to create a validation list for some cells in a row so that users can
only type in number 0 to 100 and also the alphabet "TH" for absentees. What
is the formula in the validation list. TQ.

I've been struggling with this problem for months!  Please help!
Here's the problem:
I have 10 Excel files with lists of items.  Each excel file is about
1000-2000 rows long.  The first column is an inventory number that is

I have this sheet which i am currently working on - what i would lik
to do is everytime a new bit of data is added to sheet1, i
automatically updates sheet2 (which is a datastore).  It has to be abl
to find the next blank cell in the store so data isn't overwritten.

When i am printing my paper i am looking how it goes automatique on my hard
disk in a file?? grts Peter from belgium

I'm not sure if this is possible, so any suggestions welcome.
I have a sheet that I use as a template which I then copy to create
instances of this sheet. What I would like to do is to reference a
formula for a cell on the template sheet rather than have a copy of the