I am looking for a Macro that will help me with a project for year end inventory. I have a list of SKUs in column A with their QOH in Column B. Column D contains a larger list of skus that lists the skus in Column A plus many more irrelevant ones with their ACTUAL QOH in Column E. I need the macro to search column C for a sku that matches the sku in Column A and places (copy/paste) the column E QOH of that matching sku in Column C on the line of the matched sku. I attached a sample spreadsheet that lays it out. I hope this make sense. Thanks.
Bookmarks