Hi,

i need help getting the data from sheet 2 to sheet 1 results area when i enter the work order number in sheet 1 G9

for e.g when i enter work order number in G9, all the rows that have the same work order no. will display in the results area on sheet 1


sheet 1.png

sheet 2.jpg