Match barcode between 2 sheets [Solved/Closed]

Question

Match barcode between 2 sheets [Solved/Closed]

Report

Ram - Feb 15, 2012 at 07:03 AM
TrowaD

Posts: 2690
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 12, 2021

- Dec 13, 2012 at 10:45 AM

Hello,

I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2100 lines with just barcode of products .I want to match up barcode to barcode and get everything information that needed foe 2100 lines from the 10,000 lines.Please help me

Match barcode between 2 sheets
Match data excel 2 worksheets - How-To - Excel
Compare 2 Sheets -> Summary differences ✓ - Forum - Excel
Highlight unique or duplicate on 2 sheets ✓ - Forum - Excel
Excel - Removing different rows in 2 sheets ✓ - Forum - Excel
VBA to compare column E from 2 sheets and copy entire row to sheet 3 ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Accepted Answer · 2012-02-16T10:32:54-0500

Answer 1 / 1

TrowaD

Posts: 2690
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 12, 2021

454
Feb 16, 2012 at 10:32 AM

Hi Ram,

Looks like you are in need of the VLOOKUP formula.

=VLOOKUP(1,2,3)
1: the cell/value you want to lookup. The barcode from sheet2
2: the matrix you want to look in. All the data from sheet1
3: the column you want to retrieve info from. For description 2, for quantity 3.

Select the matrix in the formula and hit F4 to make the reference absolute, do this for easy dragging.

Please post back if you get stuck (or to say thank you).

Best regards,
Trowa

Report

barcode.
Dec 11, 2012 at 09:12 PM

I am trying the similar thing with my products in warehouse. And I want those barcodes scanned could be change to red color in excel automatically, is this possible?

Report

TrowaD

Posts: 2690
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 12, 2021

454
Dec 13, 2012 at 10:45 AM

Hi Barcode,

It is possible to change color of newly added values.

More info is needed though.
What will the destination be for the barcodes (example column A)?
Do you want to color cell or letters?

To get you started, the following code will color the cell red whenever a value is added in column A:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("A:A")) Is Nothing Then Exit Sub
Target.Interior.ColorIndex = 3
End Sub

To use code, right-click on the sheets tab (name) and select view code. Paste code and try it out.

Best regards,
Trowa

Match barcode between 2 sheets [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!