This seems to be a complicated issue for me and now I'm frustrated at the lack of a solution.
I have a worksheet. Within the sheet I have created some cells that have a total at the end to automatically add the totals of the numbers entered in the cells corresponding to their topics. No issues here at all.
The problem comes in now that I have to add two more topics (operating companies) to this work area. Because I cannot create an independent excel table inside of a worksheet,..I have a problem because now by adding more columns to compensate for the two additional headings,...it throws off the entire worksheet because everything els was set to look good within the width I created it in.
What can I do? Is there a way that I can create this table and still retain the formulas in it and then insert it into this workheet so that it's in the sheet but actually independent of it if i need to widen it or expand it (add rows or columns)in the future? Can this also stay put in the worksheet so that it cannot be accidentally shifted by the end user?
I'm lost here!
Todd
Bookmarks