Find String and get values

[naveenmarapaka]

Hi,

I am looking for some genius hands on my query please and give me a solution through VBA code.

I have a workbook of more than 300 sheets
In each sheet lot of data is there, In I want to search for 2 strings. 1) Vehicle No 2) Vehicle Total in all sheets

I cant do it manually by Ctrl F and search all data in all sheets.

Here I want my result as below.


Need to first search for string "Vehicle No" and get the value of that cell and then search for its corresponding string "Vehicle total" and get the values starting from Vehicle total until Total Kms in that row.

Please note in some sheets "Vehicle Total" of a Vehicle is available on the following Sheet and not on the same sheet.

example: Sheet (Table4) Vehicle No 14811 corresponding vehicle total details are in Sheet (Table5).

Required Result should be in a new sheet like below

[mehmetcik]

Please Login or Register  to view this content.

[naveenmarapaka]

Hi Mehmat, I have no words to say thank you, it is really marvelous, its exactly the same what I want, thanks a million .