|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Feb 25th, 2002, 01:44 PM
|
#1 |
|
Board Regular
Join Date: Feb 2002
Location: Jefferson City, Missouri
Posts: 383
|
I'm looking for some way to tell if an invoice has already been input. I have a spreadsheet with 8 pages where we input our invoices. I need to prevent a duplicate entry with a msgbox warning. I have tried using data validation on a previous spreadsheet but that didn't produce the results I wanted. We input the invoice number in C9:C38, on all eight pages. If a duplicate entry is made I need to notify the user of the fact.
Sorry the other question I will work on first before I ask for help. Thanks,
__________________
I appreciate the help from everyone at Mr. Excel. viper |
|
|
|
Feb 25th, 2002, 06:23 PM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Minnesota
Posts: 92
|
|
|
|
|
|
Feb 25th, 2002, 06:45 PM
|
#3 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,317
|
Quote:
I'd like to see the ISNA+VLOOKUP formula up there changed to: =COUNTIF($A$1:A8,A9)=0 Aladin |
|
|
|
|
|
Feb 25th, 2002, 08:16 PM
|
#4 |
|
Board Regular
Join Date: Feb 2002
Location: Jefferson City, Missouri
Posts: 383
|
Thank you both. I will try both.
__________________
I appreciate the help from everyone at Mr. Excel. viper |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
