Copy and Paste

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HankW - 12 Sep 2005 17:18 GMT

Is it possible to copy a column of external data to a row in worksheet? The
column is numeric data from a financiial website source and I want it entered
into my worksheet as a row with the same number of cells.

Currently I copy 5 columns of 10 rows of data. I drag the 10 items I want
into the row I want them in in 10 steps. Than I delete the balance of the
data and reformat this area to its original state.

Thanks for your feedback.
Hank

Reply to this Message

Mike - 12 Sep 2005 17:31 GMT

The closest is Paste Special - Transpose

> Is it possible to copy a column of external data to a row in worksheet? The
> column is numeric data from a financiial website source and I want it entered
[quoted text clipped - 6 lines]
> Thanks for your feedback.
> Hank

Reply to this Message

George Nicholson - 12 Sep 2005 19:25 GMT

If the data you are copying is static, i.e., the desired values can always
be found in the same 'grid' location:
- 1) Copy the 5 column, 10 row set of data to a separate location/sheet
where it can live permanently.
- 2) Change the 10 cells in your row to point to the proper cell(s) of your
copied data.
Next time, you only need to do step 1 (& a recalc)

Either that or use PasteSpecial>Transpose, but I think my 1st suggestion is
easier to audit.

HTH,

Signature

George Nicholson

Remove 'Junk' from return address.

> Is it possible to copy a column of external data to a row in worksheet?
> The
[quoted text clipped - 8 lines]
> Thanks for your feedback.
> Hank

Reply to this Message