+ Reply to Thread
Results 1 to 5 of 5

Cell contents overwritten by successive cells...but maybe there's a way for it not to?

Hybrid View

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2010
    Posts
    3

    Cell contents overwritten by successive cells...but maybe there's a way for it not to?

    I sincerely apologize if this has been covered before. I've been searching the Internet for a while but I'm not finding the answer and I think I'm not quite sure how to ask in the search engines to find what I'm looking for.

    Here is what I would like to have;
    On one sheet (Tasks) in a spreadsheet, I am listing out a timeline of tasks needed to complete a project. The Phase label is in column A while the tasks and subtasks are entered into columns B and C on their own rows (I like to have the widths of columns A and B small (~15 pixels) so that they are indented below each other to show a hierarchy). Associated with each of these tasks and subtasks are start and end dates in columns D and E. I also have another sheet (Timeline) in this spreadsheet which represents the tasks in a graphical timeline-like format. I would like to have the same entries in columns A - E from the Tasks sheet 'copied' to the Timeline Sheet with the same indention format.

    Here's what happens;
    So the method by which I tried to 'copy' the cell data from one sheet to the other was to use this function on the cells; IF(IsBlank(Tasks!A2),"",Tasks!A2). This works that it ensures that the cell in the Timeline sheet remains 'blank', but it can really mess up the indenting thing I have going on because the cell truly isn't blank and therefore if something is entered in column B, column C with this formula takes precedence and B gets cut off. In my searches, I've learned that a formula cannot return an empty cell AND I've also learned that the fact of a formula existing in the cell will cause this problem, as well.

    So, if I've what I've explained above makes any sense and someone has a way of making this work, I would really like to know it. Otherwise, I'll just manually update both lists and move on.

    I do appreciate any help in advance. Thank you!

    Greg

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Cell contents overwritten by successive cells...but maybe there's a way for it not to?

    Hi Greg,

    Welcome to the forum.

    Suggest you to upload a sample workbook to support your query. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    06-22-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Cell contents overwritten by successive cells...but maybe there's a way for it not to?

    temp.xlsx

    Here's an example for you to look at. See the sheet, Timeline, columns A and B end up being cut off.

    Hope this makes sense.

    Greg

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Cell contents overwritten by successive cells...but maybe there's a way for it not to?

    In my searches, I've learned that a formula cannot return an empty cell AND I've also learned that the fact of a formula existing in the cell will cause this problem, as well.
    Yes.. if you apply a formula to a cell, that cell is now filled up and can return blank using formula only e.g. "" but again it is a formula that is showing this blank

    So basically you want, if any entry is entered in "Tasks" sheet, same info will show in sheet timeline .. but you don't want any formula in in timeline sheet or what ?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    06-22-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Cell contents overwritten by successive cells...but maybe there's a way for it not to?

    Yes, to your first question; So basically you want, if any entry is entered in "Tasks" sheet, same info will show in sheet timeline. When I put in the simple formula, =Tasks!B6, if there is nothing in that field, it places a '0' (zero) in the cell in the Timeline sheet. So, I used the formual, =IF(IsBlank(Tasks!B6),"",Tasks!B6). This solves the problem of have a zero in the field (it's blank then), but the cell will then cut off whatever may be in the field before it because the columns are short thin (~15 pixels) in order to create that indented look. I was hoping there was some sort of way to work around this problem so that the information in the cell does get copied, but doesn't get cut off by the next cell to the right of it.

    Greg

+ 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