Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicate invoice numbers
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 |
#2
|
|||
|
|||
Sorry!
While I was waiting to see if my message posted, I looked at some of the other questions to see if I could help someone else (not likely, but worth a try) I did find a previous question that was almost the same that was answered. I tried it and it works on one worksheet. Can I get it to work on all 5 at the same time? Thanks "pete" wrote: 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 |
#3
|
|||
|
|||
Hi pete
might help if you copy & paste the "answer" you found .... Cheers JulieD "pete" wrote in message ... Sorry! While I was waiting to see if my message posted, I looked at some of the other questions to see if I could help someone else (not likely, but worth a try) I did find a previous question that was almost the same that was answered. I tried it and it works on one worksheet. Can I get it to work on all 5 at the same time? Thanks "pete" wrote: 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 |
#4
|
|||
|
|||
Julie It's kind of a long answer( I used the web address that was given, and it walks you right through it, but like I say it looks like it only works on one page). The question is about 10 below mine titled "Preventing Duplicate Entries within a column" Thanks, Pete P.S. this is a copy and paste of one answer. To highlight duplicates: Select column A From Format menu | Conditional Formatting Formula Is: =COUNTIF($A:$A, $A1)1 Then format as Bold, or Red or whatever. "JulieD" wrote: Hi pete might help if you copy & paste the "answer" you found .... Cheers JulieD "pete" wrote in message ... Sorry! While I was waiting to see if my message posted, I looked at some of the other questions to see if I could help someone else (not likely, but worth a try) I did find a previous question that was almost the same that was answered. I tried it and it works on one worksheet. Can I get it to work on all 5 at the same time? Thanks "pete" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Invoice numbers? | Excel Worksheet Functions | |||
how do you change invoice numbers automaticly | New Users to Excel | |||
automatic order or invoice numbers | Excel Worksheet Functions | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |