On my spreadsheet I have calculations and formatting of fields etc.--many thanks Claus for the assistance.

what I have is:

A B C D E F G H
010203NN 27.50 020203YY 56.75 525251NY 175.2 101020YN 1.75

The values in columns B, D, F & H are obtained from a VLOOKUP on another table.

What I want to do is...

Total the values in the numeric columns and store them in another cell..easy, done that.

However, what I also want to do is copy the data that is in the other cells, and paste the values into another spreadsheet. The problem I am having is that the copy / paste, is pasting in the values that are stored in B, D, F & H as well. I am then having to move each column left by one to get rid of the values.

I have thought of storing the value elsewhere, but can't think of somewhere to put it, without adding to the size of the file...it is already fairly large. Another thought I had was to add the values in the total cell, by simply inserting the VLOOKUP's there...however, there are 50 of them!

Suggestions, please.

Many thanks

Duncs