Search, find, copy - paste

Micheal_P

New Member
Joined
Nov 28, 2016
Messages
6
Hello,
I am a small business owner, recently i realized that i need a program for my inventory check, but when i talked with some software companies i changed my mind because its too expensive for what i consider a simple thing, definitely not worth the money.
So here is what im asking:
My database have 3 columns 1.Barcode 2.Description(of the products) 3.Price
I want to scan the product's barcode in one cell so excel can match the barcode to the row and copy-paste the entire row where i scanned.
Im using Microsoft office 2007

Thank you in advance.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Micheal, welcome to the forum.

It's always best to include samples of your data showing exactly what you're trying to accomplish.

Please post (you can copy/paste directly from excel into your reply) your data and also show how you want it to look like in the end (kind of like a before and after). Perhaps then further clarifying wouldn't hurt either. Hope this helps.
 
Last edited:
Upvote 0
This can be easily done but we need more details

For example:

Search for value in what cell.

When this value is found in column "A" copy and paste that row where?
 
Upvote 0
This can be easily done but we need more details

For example:

Search for value in what cell.

When this value is found in column "A" copy and paste that row where?


Thank you for your reply,
In my head its like this: Lets say sheet1 A1.Barcode A2.Description A3.Price - all that is empty. sheet2 (database) same as sheet 1 but with data.
When i scan the barcode in Sheet1 A2 cell i want excel to find that barcode in sheet2 database and copy-paste the entire row in sheet1.
For example: i scan in sheet1 A2 cell which is the barcode column the barcode 5208..1 hit enter and excel find this barcode in sheet2 and fill the B2 and C2 cells from sheet1.
 
Upvote 0
Are you sure your not wanting A1 B1

You said:
For example: i scan in sheet1 A2 cell which is the barcode column the barcode

In your post you only mention "A" which is column "A" you never mentioned any "B" column
 
Upvote 0
Are you sure your not wanting A1 B1

You said:
For example: i scan in sheet1 A2 cell which is the barcode column the barcode

In your post you only mention "A" which is column "A" you never mentioned any "B" column


I will make a better post with pictures tomorrow.
Sorry if i wasn't clear, my English are not really good.

Thanks for the answers.
 
Upvote 0
Micheal_P,

Welcome to the MrExcel forum.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top