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

Hi, this is not the quickest method but it may help. the website as a whole
is a great reference point

http://www.cpearson.com/Excel/Duplicates.aspx

"Tig" wrote:

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