Search row Range in close workbook

[Vijayarc]

Hi Chanoo Team

we have master workbook in share folder with read only access, we want to search data by id by filter and copy require row value in other workbook which in our system, this is daily repeated task, want to search many times.
i want to automate by search a value, the relevant row data is to auto populate in other workbook in their respective cell (without open the master file will be good enough)
i have attache sample master file and and workbook with search box,
please help, thanks in advance

 

[Vijayarc]

Please some one help on my above query's

 

[Luke M]

No need for a macro, you can do this with VLOOKUP functions. For instance, to get Inventory Value, formula would be

=VLOOKUP($E$4, '[Master file.xslx]Sheet1'!$A:$J, 6, 0)

The important part is the 3rd argument (e.g. 6) which says which column you want to return from your data. So, you'll use a similar data for each piece of info you want, just changing the 3rd argument as needed.

 

[inddon]

Please some one help on my above query's

You can have a look at my recent thread. It uses ADO to get values from other workbook (based on a unique ID). However, the master file needs to be opened or the program will open it in a read only mode.

Only the Search functionality works:
https://chandoo.org/forum/threads/search-update-insert-a-row-in-another-workbook-table.39263/

the other thread you can have a look at is:
https://chandoo.org/forum/threads/h...to-an-excel-table-and-back.39072/#post-234169

Regards,
Don

 

[Vijayarc]

Thanks for reply, for ur clarification, the master data workbook file is shared drive path in network
It has 1,75000 rows, how the vlookup formula will work effectively.
Please share some macro it will be highly appreciated

 

[inddon]

Have you debugged the workbooks from the given threads?
One of them is using ADO connection.

Both will give the solution you are looking for.

So you have options to choose from ADO connection or via VLOOKUP (from Luke)

 

[Marc L]

Hi !

As working on a network shared drive
dramatically slows down the execution …​