This is great coding, because it shows how to extract data from multiple sheets irrespective where the data is.

All your videos are so knowledgeable. Thanks for the video. Much appreciate.

Thank you. You have explained well

You are a creative genius

How did you create that search box???

Sir, in my office we keep some files on SharePoint. Can we extract data in Excel for reporting using VBA. Please guide

Thank you sir for your video

You are great sir, as usual...

@Exceltrainingvideos

2 жыл бұрын

Many thanks

Thanks a lot :) This video is amazing

Very useful video, pls help on replacing the found word with another word

Sir your video is useful. In that how to use vlook for additional column for same searchable value.

This is very helpful, but how do i extract the whole row of the data found as per the search string

How to create search box and write as search data in multiple workbook with multiple worksheets for click to search something

You are the best,sir! Can you put the code again,please?

Thank you so much, Sir.

@Exceltrainingvideos

2 жыл бұрын

You are most welcome

I am working in a bank and needs your help. My dear friend when bank closed we export system generated transactions report in 1 excel sheet in which There is many transactions performed by system and other branches of bank also includes transactions performed by our tellers. We just filter transactions that is performed by our branch tellers. This 1 sheet is consist of different categories of Accounts sorted by separate workbooks. Like all Savings accounts transactions are in workbook 1 and all current account transactions are in workbook 2 , all remittance transactions in workbook 3 etc. We just want apply filter at once on each workbook so that we can print and attach vouchers to sperate types of Accounts that is performed by our branch tellers. If you need I can provide link of excel sheet. Looking for good response from you bye

Sir it is magic and I wonder how this code can be modified for look up purpose for eg if I have a lookup value in one workbook and I want to extract data from many other workbooks if my lookup value matches

thank you for this, it is really helpful! How can i add more folders to the search? The path has a lot of sub folders, how can I fix the macro? Thank u!

@anveshnasood9769

9 күн бұрын

Hi were you able to figure out the answer to this ?

👍You work so good. I have another different problem that I would like your help. How can I create autocomplete drop-down combobox search creteria vba code to search number and date format not only text format? Your response will be highly appreciated. Thanks in advance

@Exceltrainingvideos

2 жыл бұрын

This tutorial in Excel will guide: kzread.info/dash/bejne/kZ96sM1tYcWWaNo.html or search my channel

How can I add link to cell address found?

Thanks a lot sir

@Exceltrainingvideos

2 жыл бұрын

All the best

sir, i cant access your website

Demo sheet & code need sir

Can you post how to search more than one value. For example if I have a list of orders and I want to find these orders in the various worksheets.

Can we get this code sir

@Exceltrainingvideos

2 жыл бұрын

www.exceltrainingvideos.com/search-data-in-multiple-workbooks-automatically/

@fahedfahed8943

Жыл бұрын

@@Exceltrainingvideos link is not working would you pleeease put the code.