C
carebear
I have a lead sheet containing a task list in column D which is the
classified to which subject/functional area (in column I) the tas
belongs. There will be a total of 4 subject tabs: A, B, C, D. (Note
There are five functional areas and 4 subjects because we have "all
which applies to A, B, C, and D). I want to be able to update and ad
tasks in the lead sheet (aka "Task List" sheet) and have the old an
newly inputted tasks to flow into the appropriate subject tabs. I
between columns D and I, there are various details that should als
flow along with the task into the respective subject tabs.
Specifically, there will be blank functional areas on the lead sheet
Also, there will be many lines between an "A" subject before we see th
next "A" subject. How can the "A" tab recognize an "A" task on the lea
sheet and automatically populate itself? I would like the "A" tab t
only contain "A" tasks, omitting the blank cells and "B, C, D" tasks.
Thank you for your suggestions
classified to which subject/functional area (in column I) the tas
belongs. There will be a total of 4 subject tabs: A, B, C, D. (Note
There are five functional areas and 4 subjects because we have "all
which applies to A, B, C, and D). I want to be able to update and ad
tasks in the lead sheet (aka "Task List" sheet) and have the old an
newly inputted tasks to flow into the appropriate subject tabs. I
between columns D and I, there are various details that should als
flow along with the task into the respective subject tabs.
Specifically, there will be blank functional areas on the lead sheet
Also, there will be many lines between an "A" subject before we see th
next "A" subject. How can the "A" tab recognize an "A" task on the lea
sheet and automatically populate itself? I would like the "A" tab t
only contain "A" tasks, omitting the blank cells and "B, C, D" tasks.
Thank you for your suggestions