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