I have a wksheet with 217 rows of wx stations. I transposed the data for
each individual wx station to a more easily read column format. I would like
to link the data so that if I make a change on the original "row" wksheet, it
changes on the individual station wksheet. I can do it cell by cell
individually, but I'm thinking there must be a way to do it more efficiently?
When I try to "paste special", the box for "paste link" is no longer
selectable when I tell it to transpose the data....I am using Microsoft Excel
2007 with Window XP.