468,249 Members | 1,504 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,249 developers. It's quick & easy.

Using "Find and Replace" and "Fill Color"

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
0 2523

Post your reply

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

Similar topics

1 post views Thread by Martin Magnusson | last post: by
8 posts views Thread by Jaime Wyant | last post: by
6 posts views Thread by vigi98 | last post: by
6 posts views Thread by Marty | last post: by
6 posts views Thread by Dean Slindee | last post: by
3 posts views Thread by Louis | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.