I need a vba code competed for the excel file attached. There are too sheets in the excel file.
Sheet one is the voucher codes
Sheet two is the voucher information which is in random orders
Final Output is what it should look like at the end after VBA code is implemented – if any of the values are missing (ex. 8) then it should be skipped
The VBA code should match each cell in sheet1 column A to sheet2 column A and paste the row into the first sheet beside column A. This is just a sample of the data, the rows should be A:A as there are many more to do.