Firstly hello to all, I'm sure this will be an easy one but I haven'
used Excel in years so i know it can be done but can't for the life o
me remember how to do it.
Ok so Ive got a standard spreadsheet and I want to perform an I

When I copy a large cell, only the first 260 or so characters will copy.
Why is this happening?

Can I make it any simplier. I want to make a tracking form.
The first col. A is customer name and address,Col. B is
date of purchase, Col. C is method of payment, Col. D is
item, Col. E is Amount and Col. F is total....total is the

I need to sort several text data by their suffix, I mean, the characters
from the right-to-left order.
Any help?

I have a workbook with many worksheets and links that I
need to publish externally with links locked so that users
won't get the "The workbook you opened contains automatic
links..." message.

When I try to compare two versions of a document using MS
Word, it has been crossing out entire paragraphs in RED
and then re-writing it in Blue as if the whole thing was
changed (although only one or two words were changed).  I

I'm trying to affect several worksheets from a single macro. The WITH
Worksheet("Xyz") command, and following code, seems to work OK when the
macro is invoked when sheet "Xyz" is active, but doesn't hit XYZ if called
from another sheet. I thought the WITH would make the Active sheet

I'm a teacher who is responsible for breaking down a file with 2000
students and 200 teachers in 5+ classes each into individual department
files.
There are three NAME cells - Last name, First name, Middle initial in

I have a spreadsheet which consists of a list of invoices which grows as
the year progresses. The invoice date is in column A.
What I want to do is a calculation based on the date in the last
non-blank cell in column A. How can I refer to this cell in a formula?

anyone knows how to cicle throught the different groups created by a pivot
table?

Greetings...
I'm getting more and more sophsiticated -- but its getting scarier and
scarier...
I'd like to have a macro run when a user changes the value in a certain cell

Thanks for taking the time to look at my question.
I am drawing a blank....  I cannot remember how to control the numbe
of columns in a worksheet.  I have a little app that I have pu
together, and it only takes up about 15 columns.  I would like to mak

I notice a lot of the solutions in this NG involve macros programmed in VBA.
Can you recommend any books or other learning materials for VBA?
Carlos

When i do pivot i get the data displayed as
Contractor        Circle            Count
   X                    1                    10
                          2                    15

I have a very complicated issue, maybe you guys can help.
Here is the situation
I have 600+ records (assume they are rates) and they increase ever
year by 4%. I need to take these 30 years ahead in time not a big dea