Linking Multilpe Worksheets
Posted by Anthony on June 25, 2001 6:40 PM
Hello to all! I have approximately 6 workbooks with a total of about 16 worksheets. I would like to create a "Rollup" workbook summarizing all the data($ amount) per Region/Dicipline. e.g. East/Math, West/Reading, Southeast/Science and so on. I tried doing it the conventional way only to be told that the formula was too long. I've tried creating summaries for each worksheet, but it still appears too long.. These are pretty large spreadsheets and I can't seem to figure out how to consolidate all the info into one workbook by decreasing the formula size. Any suggestions would be greatly appreciated.