Data Consolidation: Allow User to select files on Runtime || Application.GetOpenFileName

Подписаться 272 тыс.

Просмотров 10 тыс.

50% 1

#DataConsolidator #VBA #GetOpenFileName
Hello Friends,
In this Video you will learn how to consolidate the data from multiple excel files using Application.GetOpenFileName in VBA. Application.GetOpenFileName is used to allow the user to select the files.
Download this Excel file from below given Link:
www.pk-anexcelexpert.com/data...
56 Color Index Codes:
www.pk-anexcelexpert.com/vba/...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

Опубликовано:

7 апр 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 46

@pradeepkapoor6416 2 года назад

Sir your explanation is truly mpressive. Please keep on.

@PKAnExcelExpert 2 года назад

Thanks a lot

@girishsawant8263 Год назад

Nice video !! Thanks !

@adrien8768 5 лет назад

You are the best !!!!

@varungupta5594 5 лет назад

Awesome PK..the way of taught is superb..clear each steps..thanks for your efforts..regards..Varun

@michaelmihov1651 3 года назад

Thank you sir, after so many hours of practice I finally start to understand a bit of vba.

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@RitikaSharma-dg5zc 2 года назад

Right, the way he explains... That really awesome.. I always refer only his video for my office project.

@faris-math Год назад

Very good🌷🌹🌷

@amrutchitragar3014 5 лет назад

Nice video sir

@durgesh91tomar 5 лет назад

great...

@focatfocat 5 лет назад

Great

@umeshthadhani6388 4 года назад

Great Work..!! Brilliant.!! thank you! :)

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@irfanjulianto3556 3 года назад

Thank You Sir....

@PKAnExcelExpert 3 года назад

Most welcome

@SuperHanme 2 года назад

thank YOU.

@PKAnExcelExpert 2 года назад

Welcome!

@birendraprasadsah5517 5 лет назад

Awesome video Sir!

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@waseemgamal5073 4 года назад

thank you for your knowledge can you prepare macro or any operation for mail merge between 2 file excel without word

@balamuniyandi 5 лет назад

Hi Mr. Pk, your video is too good and easy to understand... I've a couple of questions, if you have a time, answer me. 1. What is lbound and ubound 2. While consolidating, is that necessary that the data range should be same for all files?? Like row range and column range should be equal...

@paulaandreaordonezcruz9968 4 года назад

great work, but I have a question, what I have to add to the code if I have multiple sheets in the files to consolidate, but the information that I need is in just one of that sheets ? thank you

@RitikaSharma-dg5zc 2 года назад

Thank you sir for sharing all knowledgeable stuff with us.... I would like to know, if I consolidated file,. And now I need colleagues name in some column then how to add? In this Macros

@ALI-oh4kn 5 лет назад

Great sir, how to consolidate if there are 2 or 3 worksheet in same workbook.

@nikhnadig 3 года назад

Code executes very fast! Great Work ! Is there any way to print file name in a column for each of the rows copied? Thanks in advance

@SanviPatil2019 3 года назад

Nice

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@mahirbadanagki 2 года назад

can you please also show how we can import data and paste it into separate column please

@veebee3969 4 года назад

Thank you for the excellent demonstration PK. I want to clarify something: in the GetOpen... statement why do you have write *.xlsx twice; the first within brackets and the second without bracket? ... [Application.GetOpenFilename("Excel Files (*.xlsx), *.xlsx]. Noted the reference inside ( ) appears as description on the drop down box, and at the same time controls the type of files displayed. What is the purpose of the second time use of *.xlsx?

@cShade0312 3 года назад

Hi PK thank you so much for the video. PK can I ask a favor? Is there a way to lets say, to reuse the Data file again to copy from another file on a separate day? And is there a way to only read data until the program read a cell containing the word "End"? Thank you.

@nishitajain4937 5 лет назад

Sir could you upload a video to create multiuser in excel VBA

@sreekarreddy4336 3 года назад

Sir can you add a vedio . IF user wants to select folder for consolidation of data.

@GkDilaawar 5 лет назад

Nice video

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@chayankumar8061 5 лет назад

sir, thanks lot

@ahmedabdelhafiz9717 5 лет назад

Great

@samirstatuscreation3028 3 года назад

Hi Sir, Sir Aapka Ye video Muje Bohat Hi Kam Aaya Thank You Sir Bt Sir muje ek problem hor rahi hai aapne jaise logs sheet me file name past kiya hai viase hi muje consolidated_data sheets me har ek data ke same uska file name aaye aise krna hai taki hme pta lge ki konsa data kis file ka hai sir please isme help kar dijiye Your Subscriber, Samir K

@girishsawant8263 Год назад

How can we separate the file name and folder name derived through "Getopenfile" method ? I want to save a new workbook in that folder after processing the data from file that we picked in that folder.

@vij2kar 5 лет назад

Hi i need transpose macro coding file vertical to horizontal excel

@jonelatendido9836 7 месяцев назад

Where is the file to practice with? only consolidation macro is availabe, but the files to consolidate was missing in the files.

@teckhindi8291 5 лет назад

Namaste sir ji Sir ji ...Ek sheet mai school k 100 bachcho k row wise marks k record h...Subject wise... Ab mai ye poochna chahta hu..K kisi ek bachche ka record delete karne per joh marks ka total sum formula laga k show kar rakha tha...Voh automatically adjust kese hoga. matlab jis bachche ka record delete kar diya h..Toh uske marks ....Total marks mai se automatically less ho jaaye... Sum ka formula dubara na lagana pade Kya esa ho sakta h...

@Harshsanjana 2 года назад

Sir, in data consolidation file name is not showing. From which file's data has consolidated.

@PKAnExcelExpert 2 года назад

You can use our utility Tool to consolidate the data. I will show the source file also. Please watch below video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1NQj17-3u10.html

@Harshsanjana 2 года назад

@@PKAnExcelExpert Thank you

@Harshsanjana 2 года назад

Request you to please apply the code for file name in beginning or last