Copy and Paste

H

HankW

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
 
G

George Nicholson

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,
 
Top