Fully Automated Data Collator in MS Excel and VBA - Step by Step Tutorial
Рет қаралды 18,318
Күн бұрынHow to develop fully automated Data Collator in VBA & MS Excel - Step by Step Tutorial
In this tutorial, we will learn how to create a dynamic data collator in Excel with the help of VBA/Macro code. While developing this tool, we will utilise Filesystem Object (FSO) and it's methods to handle file and folder. We will also use Dialog Box to select the Folder.
This is step by step tutorial and after completing this video, you will be able to create a complex and automated collator in MS Excel. So please watch this tutorial till end. If you have a question then drop your query in comment section.
#DataCollator #TheDataLabs
Please follow the below link to download the Excel files (automated data collator) used in this video.
thedatalabs.org/automated-dat...
Please visit our website www.thedatalabs.org
Please contact us on thedatalabs@gmail.com
Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!
@GopiNath-fp5ly 4 жыл бұрын
Great work with nice presentation. Thank you.
@thedatalabs 4 жыл бұрын
Thanks for your feedback!
@AbhishekMishra-cr1tz 4 жыл бұрын
Very useful topic,You explained very well.thank u sir
@thedatalabs 4 жыл бұрын
Thanks for your feedback!
@amolbhakade7558 4 жыл бұрын
Really usefull this video thanks..!
@thedatalabs 4 жыл бұрын
Thanks for your feedback!
@ariflodhi2908 3 жыл бұрын
its great
@BANEBRO2 4 жыл бұрын
Best Way to teacher Dear Love your Content Wish u have more subscribers
@salihch3135 4 жыл бұрын
👍
@AjaySharma-em2ez 2 жыл бұрын
god of excel
@shashaapsheen8963 3 жыл бұрын
thank you very much for your efforts ..can you please suggest how to add more files later on to keep data updated in main collated file? so that do not have to make new collated file every day
@ramisignals2720 4 жыл бұрын
Super We need multi user form with multi sheets in one file For exmple user form 1 is the data for sheet number , userform2 is the data for sheet 2 We need to do 15 sheets and 15 user form in one file Search + save + printing + Reset+edit + delete buttuon for each user form and each sheet Itry this but i got conflict in modules please make some videos it will be help full Thanks
@ajaykumar-hu3py 4 жыл бұрын
great
@thedatalabs 4 жыл бұрын
Thanks for your feedback!
@beekramkhadka 4 жыл бұрын
Thank you for your video for learning many things. But even i have one query, hope for your help. The query is that if there is any one product named "A" and while transferring data from "A" product VBA user Form, If there is Qty 2 then the Qty should be display individually in row side also. for that what should I do. Hope for your soon response.
@robhaman4424 4 жыл бұрын
Thanks for this session, did you also consider to use Power Query instead of writing this code?
@thedatalabs 4 жыл бұрын
Yes, we can also use Power Query. Below is tutorial based on Power Query. Thanks! kzfaq.info/get/bejne/f9Z4grekyNKRnI0.html
@Test_yourknowledge 4 жыл бұрын
Do you have a video above the Add Data to Specific Sheet from user form? Please send me video
@nani3775 4 жыл бұрын
Could plz let me know how to create pivot tables using VBA....
@vishalthakur-360 2 жыл бұрын
I have multiple files on network and need to collect data from multiple files on same column and than paste it on my data collection file in a row .please let me know how can be it possible
@amitkanji 3 жыл бұрын
What if in one data file couple rows are blank. Will it copy the remaining data after couple of blank rows?
@rameshbankar100 4 жыл бұрын
how can we use INDEX and Match function , [ a table array in sheet1 with row and column matching cell to be used in sheet2 with cell 1 (row entry from table array) cell2 (column entry from table array) and matching result in cell 3 from table array... eg..=INDEX('sheet1'!C5:U45,MATCH(C5,'sheet1'!B5:B45,0),MATCH(D5,'sheet1'!C4:U4,0)) here sheet1 contains table array. please can you make VB codes for this formula... thanks
@09kioko 4 жыл бұрын
How do I collate data from multiple workbooks with multiple worksheets?
@thedatalabs 4 жыл бұрын
You just need to make some changes in coding and loop through all worksheets available in a particular workbook. Thanks!
@sridharkrishnappanavanerth3388 4 жыл бұрын
Sir after collating the data from each file a message is to prompted for number of lines copied and sum of lines copied after every file and finally total number of lines collated after completion of collation.
@thedatalabs 4 жыл бұрын
You can display it at the end of process as we have all the variables. You can also create Pivot Table on data and get the summary in next sheet. Thanks!
@nikhilbhor3933 4 жыл бұрын
Hello sir... I needed a little help with a data entry form on which i am working right now.... so how can i contact you???
@riyasissuedeen8007 4 жыл бұрын
I am getting run time error, while running it is showing Subscript out of range. Could you please help me?
@thedatalabs 4 жыл бұрын
Please check the range or name you are using. Thanks!
@maheshbhosle9389 2 жыл бұрын
Pls help...when I m running code its showing me debug on .title="select folder"....what I m doing wrong....what should I do
@maheshbhosle9389 2 жыл бұрын
21:00 here is that part
@pankilpatel9244 4 жыл бұрын
No need for codeing, there is GET DATA available redily. You can do much more with that without single line code
@thedatalabs 4 жыл бұрын
Yes, Power query is also a good option and I have already told in this tutorial. But we should know both options. While learning this collator one can learn FSO and other methods and that will help in developing complex collator with several decisions which cannot be done in M language. Please watch our tutorial on Power Query to collate the data. Thanks! kzfaq.info/get/bejne/f9Z4grekyNKRnI0.html
@pankilpatel9244 4 жыл бұрын
@@thedatalabs yes yes..
@GopiNath-fp5ly 4 жыл бұрын
I think we can do it in Google sheets also.
@elsayedkhalil337 4 жыл бұрын
@@thedatalabs kzfaq.info/get/bejne/mLGXdbx8v6jNcWQ.html
@elsayedkhalil337 4 жыл бұрын
@@pankilpatel9244 kzfaq.info/get/bejne/mLGXdbx8v6jNcWQ.html
@pvkkr Жыл бұрын
not working
TheDataLabs
Рет қаралды 87 М.
TheDataLabs
Рет қаралды 1,3 МЛН