Sheet 1 | |||
15-0013 | 1234 | ||
<tbody>
</tbody>
Sheet 2 | |||
15-0009 | 5432 | ||
15-0010 | 8569 | ||
16-0012 | |||
15-0013 | |||
15-0020 | 4587 | ||
16-0033 | |||
<tbody>
</tbody>
I have an excel workbook which holds a data table on Sheet 2 based on an order number (example 15-0013). I want to populate cells on the sheet by entering data on sheet 1 and pushing the information to the correct cell on sheet 2. In this example i want to push the value 1234 from cell B1 on sheet 1 to the correct row of Sheet 2, column B based on the value in Sheet 1 A1. I assume this includes looking up the correct row on sheet 2 and setting value of cell(correct row # and column B) equal to the value in sheet 1 B1. I am struggling to find an example online to follow for this VBA code. I would greatly appreciate any help you can provide on this example.