How to search for multiple occurences of data in multiple workbooks with multiple worksheets automatically using a macro.
Жүктеу.....
Пікірлер: 32
@michaeldailey40572 жыл бұрын
This is great coding, because it shows how to extract data from multiple sheets irrespective where the data is.
@rampraji Жыл бұрын
All your videos are so knowledgeable. Thanks for the video. Much appreciate.
@mohanraj-qg7nr11 ай бұрын
Thank you. You have explained well
@mohamedel-hanfy91402 жыл бұрын
You are a creative genius
@Xaviergonzalez85Ай бұрын
How did you create that search box???
@ashoktawale30252 жыл бұрын
Sir, in my office we keep some files on SharePoint. Can we extract data in Excel for reporting using VBA. Please guide
@Lafeakame835 ай бұрын
Thank you sir for your video
@veejay94312 жыл бұрын
You are great sir, as usual...
@Exceltrainingvideos
2 жыл бұрын
Many thanks
@busegunduz6131 Жыл бұрын
Thanks a lot :) This video is amazing
@viswanathan19 Жыл бұрын
Very useful video, pls help on replacing the found word with another word
@GowriShankar-ct7mh2 жыл бұрын
Sir your video is useful. In that how to use vlook for additional column for same searchable value.
@hemalc2 жыл бұрын
This is very helpful, but how do i extract the whole row of the data found as per the search string
@sivapenne13287 ай бұрын
How to create search box and write as search data in multiple workbook with multiple worksheets for click to search something
@CatalinaDragomirescu-mu8tz Жыл бұрын
You are the best,sir! Can you put the code again,please?
@MohAboAbdo2 жыл бұрын
Thank you so much, Sir.
@Exceltrainingvideos
2 жыл бұрын
You are most welcome
@haseebbaig277 Жыл бұрын
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
@ramneeksharma42262 жыл бұрын
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
@nahircaamano5638 Жыл бұрын
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 ?
@josephkimote6612 жыл бұрын
👍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
@tasneemmadihah1778 Жыл бұрын
How can I add link to cell address found?
@abdelghani95562 жыл бұрын
Thanks a lot sir
@Exceltrainingvideos
2 жыл бұрын
All the best
@brofist6482 Жыл бұрын
sir, i cant access your website
@sanpatel20562 жыл бұрын
Demo sheet & code need sir
@JacobRVA Жыл бұрын
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.
Пікірлер: 32
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.