Linking and updating mulitple lists
 

I have 7 worksheets, with information that is gathered into an 8th worksheet
as the Master List. Any editting done in the 7 sheets, is shown on the master
list. My problem is, I cannot add a new record(row) on any of the 7 sheets
and have that new record appear on the Master List. Is there a way to do
this? I have no clue how do code. Is this possible? If so and if the code is
"easy" or generic, can anyone please post it.

Thank you!

Linking and updating mulitple lists
 

Hummm, interesting. I don't think it can be done using standard references
(but some VERY creative people visit this DG oft). However, you can use
named ranges. It is possible with named ranges, but it may take a bit of
work to get it set up and working correctly. Check this out:
http://www.cpearson.com/excel/named.htm

And this:
http://www.contextures.com/xlNames01.html



Regards,
Ryan---


--
RyGuy


"Mark" wrote:

I have 7 worksheets, with information that is gathered into an 8th worksheet
as the Master List. Any editting done in the 7 sheets, is shown on the master
list. My problem is, I cannot add a new record(row) on any of the 7 sheets
and have that new record appear on the Master List. Is there a way to do
this? I have no clue how do code. Is this possible? If so and if the code is
"easy" or generic, can anyone please post it.

Thank you!