Copy and Paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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