I am working on a project management database within Excel. What I would like is when a cell is populated in Column A, a new column is automatically inserted to the left of a cell titled "* ALL PROJECTS AND TASKS TO THE LEFT*. I also would like if any cells are populated under any column from B onward, to the left of the above cell " ALL PROJECTS AND TASKS TO THE LEFT*" to automatically insert a column with that name to the RIGHT of that cell.
For example:
AG: *ALL PROJECTS AND TASKS TO THE LEFT*
Column A2: Project1
Automatically Insert Column in AG
AH: *ALL PROJECTS AND TASKS TO THE LEFT*
Column A3: Project 2
Automatically Insert into AH
and so on....
and...
B2: Task 1
AJ: Task 1
B3: Task 2
AK: Task 2
Hopefully this makes sense... if not I'll be more than happy to clarify!
For example:
AG: *ALL PROJECTS AND TASKS TO THE LEFT*
Column A2: Project1
Automatically Insert Column in AG
AH: *ALL PROJECTS AND TASKS TO THE LEFT*
Column A3: Project 2
Automatically Insert into AH
and so on....
and...
B2: Task 1
AJ: Task 1
B3: Task 2
AK: Task 2
Hopefully this makes sense... if not I'll be more than happy to clarify!