Find and display values in another Excel

[LukasUnso]

Hi all,

I am still at the beginning of my Excel adventure, but I have an interesting question because I work with several Excel files.

I have a certain number as a label (example 600). The 600 is somewhere in a 2nd Excel file under different sheets.
I now need 2 rows next to the 600 two values separated by one row each that I need to display in the 1st Excel.

The tables are also completely unsorted, i.e. after 600 there is not 601 but 601 could appear again 4 sheets further on.

Since these are not only 4 numbers in my real case but up to 100, I would not like to do that manually with several more Excel tables.

Example
Screenshot 2022-12-16 093814.png

I would be extremely grateful for any help.

Thanks!!
Lukas

[vichopalacios]

Hi Lukas
Just to make it clear:

According to the image you posted, you have two workbooks, let's call them : LeftBook and RightBook
.- RightBook has several worksheets
.- In each workshhet there are 3 relevant columns (may be more, but non relevant) containing Label, Value1, and Value2
.- Question: the label number can be repeated along the different worksheets? in your example the number 600

.- In LeftBook you write a Label number, and need to bring corresponding Value1 and Value2 found wherever they are in any worksheet of RightBook.

This can be done using VBA Macro

PS.: Better if you post a sample workbook