Copying cells from one spreadsheet to another?
I will assume by "spreadsheet" you mean a workbook(file) since you didn't answer
my questions.
Why do you think you cannot upload a worksheet to a database?
You can have multiple worksheets in a workbook each connected to a different
database application.
Copy the entire column then paste to second sheet.
Sort the column as you wish to get the other order.
Save the workbook.
You could also do this with two independent workbooks if that's your choice.
There would be no formulas to change to values but to change them, select the
cells and Copy then Paste Special(in place)ValuesOKEsc.
If you want formulas, select the column and copy then switch to other sheet or
workbook and PasteSpecialLinksOKEsc.
Now you have to deal with changing the formulas.
Gord Dibben MS Excel MVP
On Wed, 13 Jun 2007 14:45:00 -0700, Doug wrote:
Gord,
Thanks so much for the quick response and sorry it's taken so long to reply.
The "wrong column format" I was referring to means that I have a specific
column order on one spreadsheet and the second one must be in a totally
different order to upload to a completely different database.
Which brings me to my second dilemma. Since I have to upload the second
spreadsheet independent of the first, I cannot have two spreadsheets in the
workbook.
After I merge the data, is there a way to "freeze" the values so that each
cell contains only the cell value and not the formula?
Thanks again for your help!
"Gord Dibben" wrote:
Doug
Describe what you mean by "wrong column format".
What do you consider a "spreadsheet"?
A workbook or a worksheet within a workbook?
Are you copying on the same worksheet or across worksheets or across workbooks?
But yes...........you can use formulas to return data from one place to another.
Just have to know to where/from where.
Gord Dibben MS Excel MVP
On Wed, 6 Jun 2007 16:13:00 -0700, 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.
|