Hi,
This probably won't be much help to you, but multiple data sources with a
common link between them really is a job for Access, not excel.
If you moved this into access it would solve all your problems.
Thanks,
Simon
Dawnaha wrote:
I can't figure out the best way to do this:
I have 3 input data sheets. Contribution info from 3 sources. Each has
difference sections of info. They want a 4th sheet that is the summary sheet
that adds all of the other sheets and is automatically sorted without the
user doing anything.
My boss wants to input data on any of the three sheets and have it
automatically appear in the correct place on the summary sheet.
I know how to link when the source is known, but how do you make new rows
automatically get added and in the correct alpha order on another worksheet??
I was thinking something like 3-D references and ranges.
--
--------------------
Simon - UK
Email at simon22mports [ a t ] hot mail [ d ot ]com
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1