I have a master spreadsheet with all my information on it which requires me
to add 6-7 columns everytime i need to input data for a new date. This new
data is entered between other cells, and is broken up into sub categories.

These sub categories correspond to a respective seperate spreadsheet in the
same workbook.

My objective is to create a formula for each sepereate spreadsheet linking
to the "master" spreadsheet so that i can input the data in the master
spreadsheet and have the other spreadsheets update themselves (by creating a
new column when i create a new column in the master spreadsheet and inputting
the data i input in the master spreadsheet)
yes this is like creating a entire program to do this, but I can see Excel
being capable of doing this.
It would save me hours of work!

Thanks

Hi,

You might take a look at the links on this page and see if any of them
relate to your problem:

http://support.microsoft.com/search/...d=914&r ange=

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Canuckcrazy" wrote:

I have a master spreadsheet with all my information on it which requires me
to add 6-7 columns everytime i need to input data for a new date. This new
data is entered between other cells, and is broken up into sub categories.

These sub categories correspond to a respective seperate spreadsheet in the
same workbook.

My objective is to create a formula for each sepereate spreadsheet linking
to the "master" spreadsheet so that i can input the data in the master
spreadsheet and have the other spreadsheets update themselves (by creating a
new column when i create a new column in the master spreadsheet and inputting
the data i input in the master spreadsheet)
yes this is like creating a entire program to do this, but I can see Excel
being capable of doing this.
It would save me hours of work!

Thanks