Worksheet Formula Links
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 |
Worksheet Formula Links
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 |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com