$$Excel-Macros$$ Humongous Spreadsheet-- Formulas not behaving

2010-10-17 Thread SLF
I have a huge spreadsheet. Tab 2 - tab 300 are exact duplicates of a detailed form. Each form has 104 fields for information that must be entered. A mindless drone enters information into each of these forms as new business projects are created. Tab #1 is a simple table, it is my master summary

$$Excel-Macros$$ Automatic Detail Summary

2010-05-30 Thread SLF
Hello all! I am building a complex spreadsheet to track 2 weeks of payroll and projects. It needs to be a completely automatic document that can calculate everything for itself. All that will be entered is the hours. So here's my problem. I have a simple master payroll table on one tab that lo