Hm.. I have a few questions....

1. does it have to be automatically?
Can it be after say User1 types in everything and then before closing-
runs a bit of code to transfer the numbers over?

2. will the columns always be in the same position? (ie Column A in
sheet 1 goes to Column B in sheet 2) or the just the column names that
are paired ( for example- Red Delicious numbers always got into the
column Apple on the next sheet?)

3. will there be one sheet feeding a 'master sheet' or several sheets
feeding into one 'master sheet'? if so, is there a possibility that
changes will be made at once? will the order matter in this
situation?

4. does this have to be dynamic? Is there an expectation that if
numbers are changed on the first sheet will be changed on the second
sheet as well? or vice versa?

5. will there be multiple columns on the first sheet feeding into one
master sheet?

Thanks!
pim


--
Pim
------------------------------------------------------------------------
Pim's Profile: http://www.excelforum.com/member.php...o&userid=27565
View this thread: http://www.excelforum.com/showthread...hreadid=471131