Hi,
I am trying to write a code to perform a constantly running vlookup. I need the code to search for a value (Sheet2, Cell B3) in a table in a different sheet (Sheet 1, cells b2:AJ) . The corresponding value will appear in Column B and I would like it to return the values from Sheet 1 columns G:AJ into Sheet 2 cells a12:a21, b12:b21 and c12:c21.
The value to search (Sheet2 Cell B3) will change so I need the code to run automatically. If a value cannot be matched return a text box with a message "Part has not been done before"
The table I am sourcing data from in Sheet 1 will get longer so as opposed for searching forever in column AJ I would like it to search until the last row.
Any help is greatly appreciated
Thanks
Daniel
I am trying to write a code to perform a constantly running vlookup. I need the code to search for a value (Sheet2, Cell B3) in a table in a different sheet (Sheet 1, cells b2:AJ) . The corresponding value will appear in Column B and I would like it to return the values from Sheet 1 columns G:AJ into Sheet 2 cells a12:a21, b12:b21 and c12:c21.
The value to search (Sheet2 Cell B3) will change so I need the code to run automatically. If a value cannot be matched return a text box with a message "Part has not been done before"
The table I am sourcing data from in Sheet 1 will get longer so as opposed for searching forever in column AJ I would like it to search until the last row.
Any help is greatly appreciated
Thanks
Daniel