Copy and Paste Column Linked Data in Rows

  • Thread starter Thread starter BalUser
  • Start date Start date
B

BalUser

I want to copy a column of data in a row
I want this to be a link however and you can't use copy/paste
special/transpose as this copies the formulas
I want to link column data from one sheet into a row on another sheet
quickly without handling manually

e.g.
Sheet 1:

A1
A2
A3

Sheet 2:

=Sheet 1 A1 =Sheet1 A2 =Sheet1 A3
 
I will send you an add-in that I wrote to do transpose paste-links if
you send me a message with a valid email address. I don't like
guessing.....

HTH,
Bernie
 
Back
Top