Hi everyone,
I have no experience with VBA programming and I'm hoping that someone can help me. Here is the example situation:
I have a spreadsheet that contains inventory information. One of the columns has a SKU number I have defined to track the products. I have another spread sheet with SKUs of items that have sold. I need to match the two columns, then align the SKUs. I need the matching SKU to be aligned to the same row. If a SKU does not match, I need a way of identifying it.
I've attached an example XLS file. The first column will be where I placed the SKUs from a different spreadsheet. The data in all columns except the first are associated with the SKU in column "SKU". It would be best if only the cells in the column "To Be Matched" be the only cells that move when aligned.
I hope someone can help me. A VBA like this would save me so much time. I have hundreds if not thousands of entries. Doing it by hand will take forever, and I most likely will make errors.
Bookmarks