Correlating scanned data with information in a spreadsheetHow can I make Excel fetch data from a database...
is 'sed' thread safe
How do we objectively assess if a dialogue sounds unnatural or cringy?
Can the Shape Water Cantrip be used to manipulate blood?
It doesn't matter the side you see it
Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?
Is there a frame of reference in which I was born before I was conceived?
How do you say “my friend is throwing a party, do you wanna come?” in german
Wardrobe above a wall with fuse boxes
Is there any relevance to Thor getting his hair cut other than comedic value?
Canadian citizen, on US no-fly list. What can I do in order to be allowed on flights which go through US airspace?
Specific Chinese carabiner QA?
PTIJ: Mordechai mourning
PTIJ: Should I stay away from my computer?
An Undercover Army
Why are special aircraft used for the carriers in the United States Navy?
Find maximum of the output from reduce
“I had a flat in the centre of town, but I didn’t like living there, so …”
If nine coins are tossed, what is the probability that the number of heads is even?
Why do phishing e-mails use faked e-mail addresses instead of the real one?
Should we avoid writing fiction about historical events without extensive research?
How can I conditionally format my HTML table?
Why is it "take a leak?"
What is a term for a function that when called repeatedly, has the same effect as calling once?
The Ohm's law calculations of the parts do not agree with the whole
Correlating scanned data with information in a spreadsheet
How can I make Excel fetch data from a database automatically when I open the spreadsheet?Excel Spreadsheet for Barcode ScanningSelect from data, then copy to system clipboard and paste into another programHow to read QR-based vCard on Windows & Mac OS, with USB scanner?Pulling data from a range of spreadsheets into a single spreadsheet (where sheet names change)Is there a way to get/program excel to switch between sheets when you scan a spacific barcodeAdding extra functionality/logic to an Excel SpreadsheetExcel: Comparing 3 columns of data against 3 columns of dataHow can I use a barcode scanner to scan a UPC on an item and the item name, number, and cost be recorded in an Excel sheet?Excel spreadsheet/workbook data connections: Two way communication with applied filter?
I have a spreadsheet that I use to track laptops and users of those laptops. I would like to be able to scan a users id card (with a barcode scanner) and have that scanned data correlate to information such as the name of the user. The scanned data is unique to the individual and I can create a database where that data is matched to the full name of the user in a different part of the spreadsheet; the question is, how can I use that to automatically populate a specific field in the spreadsheet with the name?
microsoft-excel scanner barcode
asked yesterday
HeiferhopperHeiferhopper
1
New contributor
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a spreadsheet that I use to track laptops and users of those laptops. I would like to be able to scan a users id card (with a barcode scanner) and have that scanned data correlate to information such as the name of the user. The scanned data is unique to the individual and I can create a database where that data is matched to the full name of the user in a different part of the spreadsheet; the question is, how can I use that to automatically populate a specific field in the spreadsheet with the name?
microsoft-excel scanner barcode
asked yesterday
HeiferhopperHeiferhopper
1
New contributor
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
VLOOKUPorINDEX/MATCHare likely candidates but it's hard to say with no sample data
– cybernetic.nomad
yesterday
add a comment |
I have a spreadsheet that I use to track laptops and users of those laptops. I would like to be able to scan a users id card (with a barcode scanner) and have that scanned data correlate to information such as the name of the user. The scanned data is unique to the individual and I can create a database where that data is matched to the full name of the user in a different part of the spreadsheet; the question is, how can I use that to automatically populate a specific field in the spreadsheet with the name?
microsoft-excel scanner barcode
asked yesterday
HeiferhopperHeiferhopper
1
New contributor
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a spreadsheet that I use to track laptops and users of those laptops. I would like to be able to scan a users id card (with a barcode scanner) and have that scanned data correlate to information such as the name of the user. The scanned data is unique to the individual and I can create a database where that data is matched to the full name of the user in a different part of the spreadsheet; the question is, how can I use that to automatically populate a specific field in the spreadsheet with the name?
microsoft-excel scanner barcode
microsoft-excel scanner barcode
asked yesterday
HeiferhopperHeiferhopper
1
New contributor
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
HeiferhopperHeiferhopper
1
New contributor
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
HeiferhopperHeiferhopper
1
New contributor
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
HeiferhopperHeiferhopper
1
asked yesterday
HeiferhopperHeiferhopper
1
1
New contributor
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Heiferhopper is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
VLOOKUPorINDEX/MATCHare likely candidates but it's hard to say with no sample data
– cybernetic.nomad
yesterday
add a comment |
1
VLOOKUPorINDEX/MATCHare likely candidates but it's hard to say with no sample data
– cybernetic.nomad
yesterday
1
1
VLOOKUP or INDEX/MATCH are likely candidates but it's hard to say with no sample data– cybernetic.nomad
yesterday
VLOOKUP or INDEX/MATCH are likely candidates but it's hard to say with no sample data– cybernetic.nomad
yesterday
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Heiferhopper is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1411593%2fcorrelating-scanned-data-with-information-in-a-spreadsheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Heiferhopper is a new contributor. Be nice, and check out our Code of Conduct.
Heiferhopper is a new contributor. Be nice, and check out our Code of Conduct.
Heiferhopper is a new contributor. Be nice, and check out our Code of Conduct.
Heiferhopper is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1411593%2fcorrelating-scanned-data-with-information-in-a-spreadsheet%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
1
VLOOKUPorINDEX/MATCHare likely candidates but it's hard to say with no sample data– cybernetic.nomad
yesterday