JP

Attached is an example of what I am looking to do:-

Spreadsheet 1

Number Percentage


1 30.8475978% 179,496,001.87
2 5.5555556% 32,326,666.67
3 7.4572067% 43,391,994.40
4 16.6666667% 96,980,000.00
5 16.9122523% 98,409,013.49
6 6.1396400% 35,725,337.07
7 9.2174741% 53,634,638.21
8 7.2036070% 41,916,348.30
Total 100.000% 581,880,000.00

Spreadsheet 2

Number From 04/09/07- 28/09/07 From 28/09/07 - 10/10/07 From 10/10/07 -
31/10/07 From 31/10/07 - 06/12/07 From 06/12/07 - 28/12/07 From 28/12/07
1 5.5555556% 5.5555556% 5.5555556% 5.5555556% 5.5555556% 5.5555556%
2 11.1111111% 11.1111111% 16.1124618% 16.1124618% 21.6381378% 30.8475978%
3 16.6666667% 16.6666667% 16.6666667% 16.6666667% 16.6666667% 7.4572067%
4 16.6666667% 16.6666667% 16.6666667% 16.6666667% 16.6666667% 16.6666667%
5 16.6666667% 15.4387387% 15.4387387% 16.9122523% 16.9122523% 16.9122523%
6 16.6666667% 16.6666667% 11.6653159% 11.6653159% 6.1396400% 6.1396400%
7 16.6666667% 16.6666667% 16.6666667% 9.2174741% 9.2174741% 9.2174741%
8 0.0000000% 1.2279280% 1.2279280% 7.2036070% 7.2036070% 7.2036070%
Total 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

If the percentage share for numbers 1 and 2 chage in spreadsheet 1 I am
asking if a new column could be inserted into spreadhseet 2 to automatically
update the percentages that have changed and also those that have remained
the same.

Thank you.

--
James Waters


"JP" wrote:

If you provide more details or an example, someone might be able to
assist you.


Thx,
--JP

On Jan 4, 5:32 am, Jamesn Waters
wrote:
Using Excel 2003 is it possible for a table to be updated by the automatic
entering of a new column, each time data on another excel spreadsheet is
changed.
--
James Waters