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

[@pradeepkapoor6416]

Sir your explanation is truly mpressive. Please keep on.

[@PKAnExcelExpert]

Thanks a lot

[@michaelmihov1651]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RitikaSharma-dg5zc]

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

[@varungupta5594]

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

[@paulaandreaordonezcruz9968]

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

[@waseemgamal5073]

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

[@balamuniyandi]

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...

[@birendraprasadsah5517]

Awesome video Sir!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@umeshthadhani6388]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@girishsawant8263]

Nice video !!
Thanks !

[@RitikaSharma-dg5zc]

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

[@nikhnadig]

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

[@faris-math]

Very good🌷🌹🌷

[@veebee3969]

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?

[@adrien8768]

You are the best !!!!

[@irfanjulianto3556]

Thank You Sir....

[@PKAnExcelExpert]

Most welcome

[@mahirbadanagki]

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

[@cShade0312]

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.

[@SuperHanme]

thank YOU.

[@PKAnExcelExpert]

Welcome!

[@amrutchitragar3014]

Nice video sir

[@SanviPatil2019]

Nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ALI-oh4kn]

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

[@sreekarreddy4336]

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

[@nishitajain4937]

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

[@GkDilaawar]

Nice video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chayankumar8061]

sir,
thanks lot

[@ahmedabdelhafiz9717]

Great

[@samirstatuscreation3028]

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

[@focatfocat]

Great

[@durgesh91tomar]

great...

[@jonelatendido9836]

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

[@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]

Hi i need transpose macro coding file vertical to horizontal excel

[@Harshsanjana]

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

[@PKAnExcelExpert]

You can use our utility Tool to consolidate the data. I will show the source file also. Please watch below video
th-cam.com/video/1NQj17-3u10/w-d-xo.html

[@Harshsanjana]

@@PKAnExcelExpert Thank you

[@Harshsanjana]

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

[@teckhindi8291]

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...