Results 1 to 7 of 7

using reference with inserting rows

Threaded View

excelmanager using reference with... 10-26-2011, 03:47 AM
Azam Ali Re: using reference with... 10-27-2011, 03:19 AM
excelmanager Re: using reference with... 10-27-2011, 03:34 AM
Azam Ali Re: using reference with... 10-27-2011, 03:59 AM
excelmanager Re: using reference with... 10-27-2011, 07:59 AM
Azam Ali Re: using reference with... 10-28-2011, 12:26 AM
excelmanager Re: using reference with... 10-28-2011, 05:00 AM
  1. #1
    Registered User
    Join Date
    12-08-2009
    Location
    Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    11

    using reference with inserting rows

    My case is pretty simple. Let me explain that I really would like to know if there is a solution for this without VB.

    I have a (see attached file) workbook with 2 sheets.
    sheet 1: planning
    sheet 2: actuals

    In the planning the tasks are defined, with in the columns the planning hours.
    in Sheet 2, there is a reference made to the defined tasks, where the actuals should be written.
    Now, during the project, I want to insert a task between task 2 and task 3.
    This messes up my references AND my actuals.
    Is there any solution for this, or a smarter (preferably not in 1 sheet) to do this?

    thanks.
    Attached Files Attached Files

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