Line # Track # Cust PO # Cust PO Line # GR Reference Module
1 E00748 CC056968
This is in sheet one. I want to look up the Track # in the remaining sheets to populate the rest of the information. i.e. Cust PO#, Cust PO Line #, GR Reference, etc. How ever the track number may be in more than one sheet and I would like to return all the values that it finds.
Track ID Client PO Line Item GR # S/O Reference Module TAG ID MATERIAL DESCRIPTION QTY UOM
E00700 CC056968 3 GR-WP106-001 = 10,652 FT 347497-000 XTV, 10XTV2-CT, SR CABLE 3247 M
The remaining sheets look like this and go to row 100.