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
Bookmarks