+ Reply to Thread
Results 1 to 2 of 2

Inserting columns and keeping everything ?

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver

    Inserting columns and keeping everything ?

    The attached file is an example. The real workbook is huge, with refrences between almost all sheets. sheet 2 will use some of the totals from sheet1 for instance.

    My problem is, this workbook works flawless but has taken about 2 million hours to make.

    Now I need a new one, where the days "saturday" and "sunday" are present too - how do I insert those while making sure nothing gets broken?

    I've tried inserting a column next to friday, but that messes up something as simple as the =SUM just to the right - it doesnt include the new cell! - wont even begin to think what it does to the refrences in other sheets!

    Last edited by horsefish01; 06-10-2015 at 11:52 AM.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    Port Dover, Ontario, Canada
    MS-Off Ver

    Re: Inserting columns and keeping everything ?

    Can you supply a copy of your present workbook in place of the sample that you have given as it doesn't show how the calculations are being made between the worksheets. We need to know this in order to be confident in giving advice.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. inserting a row then keeping a formula in it
    By ollielow1993 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2013, 08:43 AM
  2. Inserting a picture, keeping sheet protected
    By bibfocal68 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-29-2012, 04:45 AM
  3. Keeping cell reference the same after inserting rows
    By muadebe in forum Excel General
    Replies: 6
    Last Post: 08-27-2012, 12:43 PM
  4. Inserting rows whilst keeping filter range.
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2010, 09:44 AM
  5. Inserting new row but keeping formulae
    By Alex Simpson in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2006, 08:20 AM


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