Otto Moehrbach said:
Provide a bit of information on the format of what you have. For instance,
where is the project name relative to all the other information on that
project? The same question for the project number? When I say "where" I
mean what column and row. Information like:
The project name is always in Column A. The project number is always in
Column B. All the data that goes with that project is in Column C starting
one row down from the project name/number. Etc, etc. Another way to ask
the same questions is:
How can the VBA code find the project number/name? How can it find all the
data that goes with that name/number? HTH Otto
news:A6AC62EB-DAC9-41FE-BE26-C828827D621D@microsoft.com...
Otto,
I do have a little VBA experience via MS Access, perhaps you could point me
to an example of how I might make a command button in Excel to
"SortByProjName", "SortByClientName".
What I'm attempting is one worksheet that all three project managers can use
to log the status of their projects, for a 'big' picture' summary review by
the boss. A snapshot of all projects in one, sortable list. Sounds simple
enough.
The problem is that one line of info per project will not do. And entering
one-line tasks with the project name, then group/sort on the project name
will not do.
What that leaves me with is a card-like concept where each project's status
'card' is a few lines long, between three and ten, say.
Col A: ProjType (sortable)
Col B: ProjName (sortable)
(the following stay in line item order within the project)
Col C: ItemNo
Col D: Delegate
Col E: DueDate
Col F: Task
Col G: Priority