+ Reply to Thread
Results 1 to 2 of 2

Inherit an insterted row,

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    sweden
    MS-Off Ver
    2010
    Posts
    1

    Inherit an insterted row,

    Hello!

    I've got a small problem! I'm trying do create a simple excel sheet for my team where everyone will be tracking their hours for projects within an individual excel sheet. Lets call this sheet "Time Tracking". This sheet is structured in the following way:

    The first column consists of a project on each row and for each column following the first one, there is a numbering of the day of the month on the first row. So if I've been working 8 hours the fourth day of the month on "project d" I will be looking in the first column for project a and the follow the columns until i find the fourth day of the month and add the amount of hours


    The second Excel sheet is an excel sheet I call "Projects". The "Time tracking" sheet inherits its projects from the "Projects" - So the first column in the "time tracking" sheet is inherited from the first column of projects. The reason for this is that we want the name of the projects to stay consistent and control which projects are active and not.

    Until yesterday, everything was working perfectly, but what happened was that I wanted to insert a new project in a specific row. So I opened up the "Projects" sheet, inserted a new row and added a new project, the "time tracking" inhertied this and the first column with projects was updated but... the other column did not move their added values to the next row.

    For clarification, I have some projects a, c, and d, I wanted to add a project b in the same column as the other but in between the rows of a and c. So I inserted a new row between Project a and C in the "projects" sheet. The "Time tracking" document already have some values added to it and when the inserted row is inherited from the "Projects" to the "Time tracking" sheet, the projects C and D are moved down one row in the first column but theirs added values do not. Instead, the new Project B has the Project C values since they did not follow the project C to the next row.

    I think i have to find a way to make the "Time Tracking" sheet inheret the inserted row but i do not know how!


    Please help!
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 04-22-2020 at 06:46 AM. Reason: Title

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Inherit an insterted row,

    Not sure if this will work for you without seeing the "Projects" worksheet, but try adding this to Projects worksheet code module and see if it does what you want...
    Please Login or Register  to view this content.

+ 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. Inserted Row NOT to Inherit Lock Property
    By amartinez988 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-13-2016, 02:00 PM
  2. Make one celll inherit the format of another automatically
    By ratiug in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-20-2015, 03:36 PM
  3. Cell Hyperlink adjustment; can they auto-reflect insterted lines?
    By BillTD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-16-2015, 04:36 PM
  4. Looking for formulas to have cells inherit formatting
    By Wingtips in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-27-2013, 09:27 PM
  5. [SOLVED] excel template inherit
    By [email protected] in forum Excel General
    Replies: 3
    Last Post: 05-03-2006, 05:10 PM
  6. [SOLVED] VSTO: Inherit from OfficeCodeBehind Class
    By Damien Anselmi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2005, 01:05 AM

Tags for this Thread

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