|re: I have figured out how to add a row for each total direct row and give it a name of non-labor direct |
You have not "added a row and given it a name".
You have added a row and placed a text string in Column B of that row.
From an Excel perspective, there's a huge difference between those 2 items. Look up Named Range in the Excel Help files to see what I mean.
Question: Can the value for Total Direct be a hard number or does it have to be a formula?
In other words, can we let VBA calculate the value based on the existing numbers and then place that number in the cell or do you need it to be a formula so that the numbers can be changed later on and the Total Direct value will reflect those changes?
Please note: Before posting Data or Code, read this How-To.