EXCEL 2016 Data Validation with Automatic input
up vote
-2
down vote
favorite
I am trying to get Data Validation on scanned barcodes.
Using an APP on my android phone the scanned barcode gets transferred to an excel file. I want to prevent scanning a barcode twice.
I am using data validation
=COUNTIF($A$1:$A$20;A1)=1
This works fine when I enter the data manually but not when the data gets transferred from my phone to excel.
Is there any other solution to do this validation so that one gets an error message when a barcode is scanned twice?
excel validation barcode barcode-scanner excel-2016
asked Nov 11 at 13:58
Jessy Stas
12
|
show 2 more comments
up vote
-2
down vote
favorite
I am trying to get Data Validation on scanned barcodes.
Using an APP on my android phone the scanned barcode gets transferred to an excel file. I want to prevent scanning a barcode twice.
I am using data validation
=COUNTIF($A$1:$A$20;A1)=1
This works fine when I enter the data manually but not when the data gets transferred from my phone to excel.
Is there any other solution to do this validation so that one gets an error message when a barcode is scanned twice?
excel validation barcode barcode-scanner excel-2016
asked Nov 11 at 13:58
Jessy Stas
12
An alternative solution is to use the Excel function to remove duplicates from the list when you open the file with VBA in workbook open
– Andreas
Nov 11 at 14:27
That's not really a solution here as we want to use it as a ticketing service. each ticket gets scanned and if someone wants to enter with a barcode which is already scanned we should get a warning.
– Jessy Stas
Nov 11 at 14:54
But that means you need to send the error back to the phone that scanned the barcode. I don't think you will be able to do that.
– Andreas
Nov 11 at 15:05
I believe a website could give you said feature. Just an input field that you scan the barcodes to and a smal code that removes the barcode from the list when it's scanned. If a wrong/duplicate is scanned you could create an error message. But using Excel it probably not the solution to your problem.
– Andreas
Nov 11 at 15:09
1
So it's only one man job to do the scanning? In that case you can use on sheet change.
– Andreas
Nov 11 at 15:26
|
show 2 more comments
up vote
-2
down vote
favorite
up vote
-2
down vote
favorite
I am trying to get Data Validation on scanned barcodes.
Using an APP on my android phone the scanned barcode gets transferred to an excel file. I want to prevent scanning a barcode twice.
I am using data validation
=COUNTIF($A$1:$A$20;A1)=1
This works fine when I enter the data manually but not when the data gets transferred from my phone to excel.
Is there any other solution to do this validation so that one gets an error message when a barcode is scanned twice?
excel validation barcode barcode-scanner excel-2016
asked Nov 11 at 13:58
Jessy Stas
12
I am trying to get Data Validation on scanned barcodes.
Using an APP on my android phone the scanned barcode gets transferred to an excel file. I want to prevent scanning a barcode twice.
I am using data validation
=COUNTIF($A$1:$A$20;A1)=1
This works fine when I enter the data manually but not when the data gets transferred from my phone to excel.
Is there any other solution to do this validation so that one gets an error message when a barcode is scanned twice?
excel validation barcode barcode-scanner excel-2016
excel validation barcode barcode-scanner excel-2016
asked Nov 11 at 13:58
Jessy Stas
12
asked Nov 11 at 13:58
Jessy Stas
12
asked Nov 11 at 13:58
Jessy Stas
12
asked Nov 11 at 13:58
Jessy Stas
12
asked Nov 11 at 13:58
Jessy Stas
12
12
An alternative solution is to use the Excel function to remove duplicates from the list when you open the file with VBA in workbook open
– Andreas
Nov 11 at 14:27
That's not really a solution here as we want to use it as a ticketing service. each ticket gets scanned and if someone wants to enter with a barcode which is already scanned we should get a warning.
– Jessy Stas
Nov 11 at 14:54
But that means you need to send the error back to the phone that scanned the barcode. I don't think you will be able to do that.
– Andreas
Nov 11 at 15:05
I believe a website could give you said feature. Just an input field that you scan the barcodes to and a smal code that removes the barcode from the list when it's scanned. If a wrong/duplicate is scanned you could create an error message. But using Excel it probably not the solution to your problem.
– Andreas
Nov 11 at 15:09
1
So it's only one man job to do the scanning? In that case you can use on sheet change.
– Andreas
Nov 11 at 15:26
|
show 2 more comments
An alternative solution is to use the Excel function to remove duplicates from the list when you open the file with VBA in workbook open
– Andreas
Nov 11 at 14:27
That's not really a solution here as we want to use it as a ticketing service. each ticket gets scanned and if someone wants to enter with a barcode which is already scanned we should get a warning.
– Jessy Stas
Nov 11 at 14:54
But that means you need to send the error back to the phone that scanned the barcode. I don't think you will be able to do that.
– Andreas
Nov 11 at 15:05
I believe a website could give you said feature. Just an input field that you scan the barcodes to and a smal code that removes the barcode from the list when it's scanned. If a wrong/duplicate is scanned you could create an error message. But using Excel it probably not the solution to your problem.
– Andreas
Nov 11 at 15:09
1
So it's only one man job to do the scanning? In that case you can use on sheet change.
– Andreas
Nov 11 at 15:26
An alternative solution is to use the Excel function to remove duplicates from the list when you open the file with VBA in workbook open
– Andreas
Nov 11 at 14:27
An alternative solution is to use the Excel function to remove duplicates from the list when you open the file with VBA in workbook open
– Andreas
Nov 11 at 14:27
That's not really a solution here as we want to use it as a ticketing service. each ticket gets scanned and if someone wants to enter with a barcode which is already scanned we should get a warning.
– Jessy Stas
Nov 11 at 14:54
That's not really a solution here as we want to use it as a ticketing service. each ticket gets scanned and if someone wants to enter with a barcode which is already scanned we should get a warning.
– Jessy Stas
Nov 11 at 14:54
But that means you need to send the error back to the phone that scanned the barcode. I don't think you will be able to do that.
– Andreas
Nov 11 at 15:05
But that means you need to send the error back to the phone that scanned the barcode. I don't think you will be able to do that.
– Andreas
Nov 11 at 15:05
I believe a website could give you said feature. Just an input field that you scan the barcodes to and a smal code that removes the barcode from the list when it's scanned. If a wrong/duplicate is scanned you could create an error message. But using Excel it probably not the solution to your problem.
– Andreas
Nov 11 at 15:09
I believe a website could give you said feature. Just an input field that you scan the barcodes to and a smal code that removes the barcode from the list when it's scanned. If a wrong/duplicate is scanned you could create an error message. But using Excel it probably not the solution to your problem.
– Andreas
Nov 11 at 15:09
1
1
So it's only one man job to do the scanning? In that case you can use on sheet change.
– Andreas
Nov 11 at 15:26
So it's only one man job to do the scanning? In that case you can use on sheet change.
– Andreas
Nov 11 at 15:26
|
show 2 more comments
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53249475%2fexcel-2016-data-validation-with-automatic-input%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
An alternative solution is to use the Excel function to remove duplicates from the list when you open the file with VBA in workbook open
– Andreas
Nov 11 at 14:27
That's not really a solution here as we want to use it as a ticketing service. each ticket gets scanned and if someone wants to enter with a barcode which is already scanned we should get a warning.
– Jessy Stas
Nov 11 at 14:54
But that means you need to send the error back to the phone that scanned the barcode. I don't think you will be able to do that.
– Andreas
Nov 11 at 15:05
I believe a website could give you said feature. Just an input field that you scan the barcodes to and a smal code that removes the barcode from the list when it's scanned. If a wrong/duplicate is scanned you could create an error message. But using Excel it probably not the solution to your problem.
– Andreas
Nov 11 at 15:09
1
So it's only one man job to do the scanning? In that case you can use on sheet change.
– Andreas
Nov 11 at 15:26