Linking Multiple Source Columns To A Single Destination Column

E

excelnooby

From reading other threads, I learned how to reference or link a sourc
column to a destination column on a different sheet within a workbook
ie. =Sheet1!A:A

My question is, How do I link multiple source columns to a singl
destination column? So any data typed in any of the specified sourc
columns on sheets 1-6 will automatically appear in the next availabl
cell in the destination column for sheet 7.

If I am making any sense.

Thanks
 
P

Puppet_Sock

excelnooby said:
From reading other threads, I learned how to reference or link a source
column to a destination column on a different sheet within a workbook.
ie. =Sheet1!A:A

My question is, How do I link multiple source columns to a single
destination column? So any data typed in any of the specified source
columns on sheets 1-6 will automatically appear in the next available
cell in the destination column for sheet 7.

If I am making any sense.
Click to expand...

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
 
A

Ardus Petus

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

Cheers
 
E

excelnooby

Puppet_Sock said:
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
Click to expand...


yikes....me thinks i am in way over my head. what I was trying to do
was link column A on sheets 1-6 so that any data typed into any cell on
column A on any of the 1-6 sheets will also automatically appear on
column A on sheet 7 on the next available blank cell.

SO for example...If I make an entry on Sheet 1 Column A Cell 5 it will
automatically appear on Sheet 7 Column A Cell (whatever the next blank
one is could 5 or 500). If I make an entry on Sheet 4 Column A Cell
400 it will automatically appear on Sheet 7 Column A Cell (whatever the
next available blank cell is).

So the next available blank cell on Column A on sheet 7 is always the
destination. The source is always any cells on Column A on sheets
1-6.

VBA code is waaaay over my head. But thanks for the help AP & Socks!!!
 
D

dbahooker

can't you just refer to the other cells?

i would reccomend not using excel, excel sucks

learn a database and maybe you won't be stuck working for $20/hour


-Aaron
 
Top