Pasting with links when transposing

[simon]

XP/Office 2003 Profssional

I want to copy a financial spreadsheet and
paste "transposed" - so the row items become columns
headings that I can use as dabase field names

Problem: I need the need transposed sheet cells to remain
linked to the original spreadsheet cells so it will
automaticaly update as the numbers change - however
the "link" option greys out when u select "transpose"
under paste special options

OR is it possible to make the 1st A rows function as
column headings for field name purposes?

OR can u fix the cell references so they dont change when
using the paste special option with transpose

Thks

 

[Bernie Deitrick]

Simon,

Reply privately to me with your email address and I will send you a
copy of an add-in that I wrote to do that. It will add an option to
the right click menu to produce transposed links for the current
selection.

HTH,
Bernie
MS Excel MVP