T
Tig
Hi,
I have five worksheets representing each week of the month ("week 1", "week
2" etc. Data from each sheet is summarised on a sixth sheet
("Consolidation"). Workers enter the project code they have worked on in
U19:U49 in each weekly sheet. Some rows in column 19 can be blank and some
project codes can be duplicated across the five sheets.
On the Consolidation sheet, I'd like to provide a list of all projects that
are represented in the weekly sheets as a check to ensure none are missed for
billing.
Is there a non-vba way of doing this?
Thanks in advance.
Tig
I have five worksheets representing each week of the month ("week 1", "week
2" etc. Data from each sheet is summarised on a sixth sheet
("Consolidation"). Workers enter the project code they have worked on in
U19:U49 in each weekly sheet. Some rows in column 19 can be blank and some
project codes can be duplicated across the five sheets.
On the Consolidation sheet, I'd like to provide a list of all projects that
are represented in the weekly sheets as a check to ensure none are missed for
billing.
Is there a non-vba way of doing this?
Thanks in advance.
Tig