Need VBA Code for Inventory Sheet

[KB_02]

Hello all. This is my first port here and I am hoping you can help. I am writing an inventory sheet for my company to track some serialized items. In this sheet, I need to include a tracking page for every item sold (easy, I've done that part), as well as a sheet to track voided (damaged/returned) items. I have found a simple way to do this through VLookUp, but as I could literally have hundreds of thousands of rows on my tracking sheet, copying a formula down to the bottom of the sheet makes the sheet so big that simple calculations take 5 minutes. I need to write a VBA Macro for this purpose.

While I love Excel and have become a pretty good wiz at using formulas, I must admit that I am nearly clueless when it comes to VBA.

Here is what I want to do:
- Look at the value in cell A4 (starting cell) on sheet “Voids” and find that value in Column B onsheet “Tracking.”
If Value is found in "Tracking," type in “Voided” in column D in the samerow as where the value is in column B.
- Then, loop down to A5 on "Voids" and repeat and keep looping and repeating until all lines on "Voids" have been accounted for.

ALSO, add to this mess, as this will be a new tracking system, we may get some items back where the serial number is not on this tracking sheet. I am assuming I can add an IF function to simply go on to the next line if the number is not found?

 

[tonyyy]

And again, you're very welcome...