Search and Consolidate Data from Multiple Worksheets using Excel VBA
Have you ever imagined to search a certain text in multiple worksheets and consolidate the data into a single place in Excel? In this tutorial, I will teach you to create a small search tool that will search for data in multiple sheets across different columns and show you the result into a single place.
Here, I have taken an example of Employee Data. The employee records kept into 6 worksheets based on their Zones such as North, East, West, South, Central, North East. The first sheet is the Search that will do the magical search and consolidate the data.
In the Search sheet, there is a place provided to Enter Search Criteria. You can write any keyword such as:
amit
manager
finance
delhi
The keywords are not case-sensitive. You do not have to write the full text. You can write partial keywords. After entering the keyword, just press Enter. It will search the keyword you enter in all the sheets and bring those data into the Search sheet. It will also show you the number of records found. During the search, the excel status bar will show Searching...
📂 Download the file: futureinhands....
🙋♂ Join our Private Facebook Group: bit.ly/2Qs2JCL
📚 Want to see more awesome content like this as soon as it is published: goo.gl/K99P4j
👍 If you found this video useful, don't forget to give a thumbs up.
✍ What did you like the most about this video? Let me know by adding a quick COMMENT or question below.
👮♂ ABOUT VIVEKANANDA SINHA:
An MCA Professional and a Microsoft Certified Microsoft Office Specialist, Vivekananda is working as a Chief Mentor and currently heading Future in Hands. He worked with the Top corporates like Mphasis, Motherson Group with 10+ years of industry exposure. He received several Best Trainer Awards from corporates for Microsoft Office based workshops. He facilitated 100000+ professionals from 500+ companies like Taj Group, ICAI, British Council, BSI, NIIT, IndiaMart, MetLife, Mahindra and lots more from Executive level to Sr. Management. Learners say his sessions are like magic shows.
🌐 LinkedIn Profile: / vivekananda-sinha
📺 PICTURE & VIDEO CREDITS:
www.pexels.com
www.pixabay.com
🎤 GEARS, I USED TO CREATE THIS TUTORIAL
Screen Recorder: amzn.to/2qqiIYR
Microphone: amzn.to/34WApyn
🌐 SHARE, SUPPORT, SUBSCRIBE !!!
Subscribe: goo.gl/K99P4j
KZitem: / futureinhands
Twitter: / myfutureinhands
Facebook: / futureinhands
LinkedIn: / future-in-hands
Google Plus: plus.google.co...
Website: futureinhands.com
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#FutureInHands #VivekanandaSinha #MicrosoftExcel #MicrosoftOffice #ExcelVBA
Негізгі бет Search and Consolidate Data from Multiple Worksheets using Excel VBA | Vivekananda Sinha | Video 62
Пікірлер: 205