+ Reply to Thread
Results 1 to 4 of 4

Creating independent table?

  1. #1
    Registered User
    Join Date
    12-10-2003
    Posts
    41

    Creating independent table?

    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
    Todd P. Dolce

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    For me, I need more information on your sheet's layout and what you mean by 'totals at the end'. Do you want to insert columns/rows and NOT have them included in your totals {SUM}?

    Can you give some examples of your data layout and just what it is you are trying to accomplish?

    Thanks
    Bruce
    The older I get, the better I used to be.
    USA

  3. #3
    Registered User
    Join Date
    12-10-2003
    Posts
    41
    Here's what I did. It works,...albeit clumsy a bit,..but it does work.

    Imagine a section of your worksheet consisting of 7 columns wide and 3 rows deep. The first row is the subject headers. The second and third all are cells that require numbers entered by the end user. These numbers are simply automatically totalled in the total cell which makes up the last cell in the 3rd row.

    This all works just great until someone tells me they need two more columns added. This cannot be done without adding columns throughout the whole sheet, thus throwing off the other parts of the sheet.

    What would be cool is if you could independently split a cell without effecting the entire sheet.

    What I did: I created the same work section area (7 columns wide ((changed to 9)) with 3 rows deep ) in a new sheet. Saved it as a new file. Imported this file into the worksheet as an object and simply sized it and positioned it where I wanted it. Problem is that the person has to double click it to make it editable. Not really a big deal (excpet for some of our folks) and the trade off is having a section independent of the parameters of the worksheet.

    td

  4. #4
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Spreadsheet layout management is always an issue. Adding/Deleting columns/rows can (and often does) mess up other portions of a sheet. Splitting cells is, of course, not an option... that could get REAL ugly....

    I find it is often much better to utilize multiple sheets to gather various bits of data, then combine on a Summary sheet.

    Editing on one sheet won't mess up all of the others and can be simply edited on the Summary.

    Good Luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1