unique copy
 

Hello All (I apologize in advance for the wordiness)

I need some direction please. I have a sheet where users
fill out 21 cells in a particular row in a worksheet that
is dependant to their dept.
There are 12 department worksheets and one master in the
workbook. I would like to periodicaly update the master
with the inputs that were done since the last update.
Each sheet will have, among many criteria, a department
and a project number. The project number will never
repeat by dept, but may repeat on a different worksheet.
(I would concantenate the dept name and project number to
create a unique ID).
I guess on each update, I would need to check the master
then each worksheet and copy and paste what was not
present on the master.

The only way I know to check is row by row, I know there
is a faster way out there, please help.

Thanks