Not clear sense.

It's always easier to specify in detail what you want to do, rather
than thrash around seeing what you are able to do.

It seems like you want Excel to detect that you've typed new data
and link it into a new column that was not previously linked. So,
suppose you start out with nothing typed. Then the user types,
on sheet3, in cell A1, the text "first" and then looks to see what
that does. Do you want that in Sheet 7, cell A1? Do you want
Excel to notice this change and add the link itself? Or do you want
the link to be pre-existing?

So, let's go on from where we were. The word "first" is in Sheet3!A1.
The user now flips over to Sheet5, and in cell A1, types the text
"second" and looks to see where that goes. What do you want
to appear on Sheet7, and where? And, again, do you want Excel
to notice this change and add the link? Or do you want the link
to be pre-existing?

So, now you should see the idea. When the user adds new text,
on any sheet in any cell, what do you want to appear on Sheet7?
And where? And do you want this link to be pre-existing or do
you want Excel to detect the change and add the link?

If you want it pre-existing, presumably stuff in, for example,
Sheet3!B6 always goes to the same place on Sheet7. If it
does go. That should be fairly simple, you just add the links
as you've already got that will put the text where you want it.

If you want Excel to detect the change and add the link, then
you need to handle events. For starters, use the macro recorder
to record adding a link of the type you want. That will give you
some good hints how to add links through VBA code. Then
look up how to handle events, either in the on-line helps or
back through the google group microsoft.public.excel.
Socks

What you want could be done with a piece of VBA code, not regulat Excel
functions.

Cheers
--
AP

"excelnooby" <excelnooby.28omay_1149095701.039@excelforum-nospam.com> a
écrit dans le message de news:
excelnooby.28omay_1149095701.039@excelforum-nospam.com...