Help on linking and copying cells

  • Thread starter Thread starter Wayne Burritt
  • Start date Start date
W

Wayne Burritt

Hi: I have over 50columns of data, arranged by row. So, each row indicates
a single record. Some of this data is streaming live and there are lots of
calculations. What I'd like to do is be able to transpose the data from
rows (horizontal array) to columns (verticle array) and keep the data alive.
I can't use the paste special/transpose feature because it converts the live
data to values. I could link the new vertical array to the old horizontal
array, but I'm constantly adding new rows (records) of data, which would
mean too much linking. Any ideas? Wayne
 
Wayne

Use the TRANSPOSE function and link but allow for
additional data - ie link to a larger range. This has to
be array entered.


Tony
 
Back
Top