Forum Discussion
Excel Problem with indenting
I have a workbook with a 3 sheets to show all projects my teams are working on. The first sheet is a dashboard showing Project details. You can select "ALL Project" or individual projects. The cen...
It isn't clear to me what the problem is precisely. Which cell(s) exhibit the problem, what do you see currently and what do you expect?
NB: I see you are using OFFSET intensively. Note that that is a volatile function which recalculates regardless whether anythin in its precedents has changed. It potentially makes your model slow.
NB: I see you are using OFFSET intensively. Note that that is a volatile function which recalculates regardless whether anythin in its precedents has changed. It potentially makes your model slow.
Thank you for your input. I would like the Project tab to show ONLY tasks for the Project selected in the drop down on the tab (cell K1) It should scroll through looking at Column R, which contains the Project selected in K1 and only show appropriate tasks. In addition, for selected tasks, indent based on WBS number. (no decimal, no indent, 1 decimal - 1 space indent, 2 decimals - 2 space indent and so on)
I am new to excel, and downloaded this template and modified it to better suit my need and correct it where it was not working as expected. I don't know an alternative to OFFSET, yet.
Any input is appreciated!!!