| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Block copy/insert of 5 rows, then update formula below?
I have a vacation/training tracking spreadsheet where there are 5 rows for
each associate. The body of the section has month titles (jan - dec) and below each is a cell for training, holiday, vacation. In the 5th row, there is a utilization percent calculated. All of this is summarized in a section below the associates which calculates overall team utilization. The problem I have is that when I copy/insert a new associate section, the formulas below break and I have to manual enter the cell locations for each month's training/holiday/vacation. Can this be automated? Sample of associate section: January February Training Holiday 1 Vac/Prsn Util % 95.45% 100.00% Sample of totals section: January February Days OOTO 9 0 HPM 176 160 HPM*Emp 1584 1440 Hrs OOTO 72 0 TeamUtil % 95.45% 100.00% Formula that breaks when I insert new associate: Days OOTO for January =SUM(E6,E7,E8,E12,E13,E14,E18,E19,E20,E24,E25,E26, E30,E31,E32,E36,E37,E38,E42,E43,E44,E48,E49,E50,E5 4,E55,E56) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Insert rows | Excel Discussion (Misc queries) | |||
| insert rows and update linked cells in multiple workbooks | Excel Discussion (Misc queries) | |||
| Macro that will Cut rows and then insert-copy or append | Excel Discussion (Misc queries) | |||
| insert rows and update linked cells | Excel Discussion (Misc queries) | |||
| Copy/Insert rows with formulas | Excel Worksheet Functions | |||
Threaded Mode
