The first page of my workbook is a summary sheet. Each time I run my macro it builds a new estimating sheet. I could make a limitless number of estimating sheets per workbook. I am trying to make a table (that I am limiting to 15) on my summary sheet that gives me each individual job total separately vs. a "sum of". Can this be done by a formula, or do I need a macro. I would prefer not to use a macro for performance reasons, but if I need a macro, do I need a separate macro for each cell? Lastly, can I make the macro auto update as data is entered?
