Hi please can someone help me with a code to do the following.
in workbook 1 i want a search box let's say cell A1 where I've inserted a search box from developer tab.
when a value is entered and searched in workbook 1 cell A1.
the search area is in workbook2 in column let's say A . (i can change the code when created)
When the value has been located let's say it was found in cell A23 i want it to select a certain range row 23 lets say A23,b23,k23,O23,P23
to display the findings in workbook 1 in a better range A2:A5.
This would need to work for any row the data was found, not just A23 it could be A62 it would then display A62,B62,K62,O62,P62
Thanks in advance
if this is too much i understand.
in workbook 1 i want a search box let's say cell A1 where I've inserted a search box from developer tab.
when a value is entered and searched in workbook 1 cell A1.
the search area is in workbook2 in column let's say A . (i can change the code when created)
When the value has been located let's say it was found in cell A23 i want it to select a certain range row 23 lets say A23,b23,k23,O23,P23
to display the findings in workbook 1 in a better range A2:A5.
This would need to work for any row the data was found, not just A23 it could be A62 it would then display A62,B62,K62,O62,P62
Thanks in advance
if this is too much i understand.