If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tables in Excel Spreadsheets
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 |
#2
|
|||
|
|||
Tables in Excel Spreadsheets
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 |
#3
|
|||
|
|||
Tables in Excel Spreadsheets
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 |
Thread Tools | |
Display Modes | |
|
|