Thanks for the feedback Doug.

Glad to hear you've got it working.


Gord

On Wed, 13 Jun 2007 16:36:01 -0700, Doug wrote:

Gord,

You're right. I forgot to clarify what I meant by "spreadsheet." What I
mean is a single sheet within a workbook. The problem of uploading the
spreadsheet to the database is that it's a proprietary program that will pull
whatever's in the cell from the specifically-named sheet into the database.
So if there's a formula in the cell, the uploaded info will be the formula,
not the value. Which, of course, won't work.

But I didn't know about the "Paste special" option - which is exactly the
answer I was looking for.

Thank you again for your help! You've saved me a tremendous amount of time.

- Doug

"Doug" wrote:

How do I copy info from one excel spreadsheet column into another using a
formula rather than use copy/paste? The original spreadsheets are in the
wrong column format and I'm trying to avoid endless copying/pasting.