Capture1 Sheet.JPG

Capture 2 sheet.JPG

Hey there,

I'm having an issue pulling data from on sheet and getting it to another. All the examples i've seen online online provide the filters if im pulling a block of data in rows and applying it to rows but in the pasted image as you can see I need a list for example in Sheet 2 A1 "location" and apply it to a Row 13I on Sheet 1.

Please let me know if you have any ideas or recommendations, I can use a data validation drop down list but I really need it to auto-complete when typing.

really appreciate any help!