I have a spreadsheet that has 5 worksheets in it, that are purchase ledgers.
(One for each week of the month). I would like to know if there is some way
to have an error message pop up if someone enters a duplicate invoice number
on any one of the 5 worksheets.

Thanks

Pete