When I try to copy multiple cells that are not in sequence I highlight the
first cell then I use the Ctrl key to highlight the second and after I have
highlighted several cells it wants to jump off the first cell and only
highlight the last cell.  Can someone tell me why?

Morning!
I wonder if someone could please help me with what I guess is a
formatting problem.
I want to run a macro from a 'forms' button, but I can't format the

I need help coping all column and header info brought over from one
spreadsheet to another with out copying and pasting everything. Is this
possible and how do you do it?

I guess it is an easy one, but I cannot solve it my own.
I have two cells for a reference list.
Cell A1 contains a name of an author, Cell B1 contains an article
title.

In the vlookup formula, the range entered includes the columns that need to
be searched for matching or similar values and the range also includes the
column from which the corresponding value has to be returned. What if there
are 2 or more columns within that range that match ...

I am trying to create a text file of email addresses.
I have exported my addressbook from Outlook & deleted all the info I don't
want & am left with 3 columns, First name, Last name & Email address.
I would like for them to wind up in a text file following the format

Error message when saving.
You cannot save to this file format when the VBA project is protected.
You may unprotect the VBA project by choosing the Properties command on the
Visual Basic Editor's Tools menu, and entering the password for the active

I am a total novice, but trying to teach myself some tricks.
In Query, I know I can combine two columns of data with this
expression:
Cal.REF+Cal.NOTES

Is there a way I can test the contents of a cell to see if it is a date?
Thanks.

Our employees that are called for emergency work on designated holidays
earn two types of reimbursable time.  If they work during what would
have been their normal shift they receive "H" leave for those hours.  If
they work outside (whether called in prior or extend beyond or ...

i have excel 2003. how do you make it so to have a specific table/char
to follow the scroll. i want the chart to show all the time when
scroll up or down
--

Group,
Another question I have is, is there a way to have variable ranges used
for functions such as autosumming?  For example, let's say the user
enters a 5 in a given cell, and the purpose of that 5 is to tell the

I have upgraded to excel 2003 from works 7.0. It will not print. The "save"
file window occurs. Even after saving, it will not print!

lets say you have 1 column (A) of data and it goes to row 5, You inser
a  new Column A and shift everything to the right. So now you have
blank Column A and a Column B that has 5 rows of data.
How do I find the cell in Column A that would match the last row o

Hello everyone,
I've never really worked with pivot tables, but what they do is simila
to what I want with one exception.  I don't want it to give me any sum
which it seems to be doing automatically.  I was able to hide certai