Search value in separate workbook and copy found value into original workbook.

Luke1690

Board Regular
Joined
Jul 26, 2022
Messages
101
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top