By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,225 Members | 2,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,225 IT Pros & Developers. It's quick & easy.

Using "Find and Replace" and "Fill Color"

P: 3
This is a long shot, but I thought I'd try it. I am currently using excel as an inventory tool. I currently have a hand-held scanner plugged into a laptop for reading barcodes. Using the "Find and Replace" fuction, I scan the merchandise which then searches the spreadsheet for the matching inventory number. When it is found, I highlight that cell in yellow. After scanning and coloring all of my inventory I can then see exactly what is unaccounted for. Using this program has definately helped speed up the entire process but I still feel I could save significant time in this process. I'm mostly self taught using excel, and I'm not bad with formulas. But I think it's going to take more to get this to work. What I would like is a macro that incorprates the "Find and Replace" fuction so that when I scan the merchandise sku into the "Find and Replace" dialogue box, it will automatically fill that cell yellow when found and return me to the "Find and Replace" dialogue box with no further clicking on my part. Currently I have to scan the barcode, then click the "Fill Color" Button, then reclick on the "Find and Replace" Dialog box and then delete the old number before I can continue with the next item. It sounds kind of petty, but would save a ton of time in the long run. Like I said, I'm thinking this is a long shot, but I thought I'd let you experts have a go at it.


Sep 5 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.