I was stuck and you got me over the hurdle, thank you so much!!!!

If all excel sheets in subfolder have the same format and the required data is scattered in different cells. Then how to put such data in a row in sheet2 (master sheet)?

Thanks Dinesh.

Very helpful

Hi Dinesh Sir-If there are multiple sheets and i want copy from specific sheet only let say sheet1?

Sir if I want to copy specific cells let say C4,D16 and B12 from subfolders and paste it in the master sheets as u did...can u help me

Awesome, thank you so much sir, is there any video so i can learn from starting as I am a beginner.

hello sir, could you please help me out in this code?)(i want to call a function (whose return value should be an array) in sub, also there is one argument as integer in that function, which will go from sub to that function. see this code. sub ram() k = 5 Call test(k) ' how to print this array "test", AND how to copy this" test array in other array??? End Sub Function test(k) As Variant Dim arr(0 To 100) As Variant For i = 0 To k arr(i) = i * i Next i test = arr() ' i want to return this arr to test End Function '##cant print test array and 13 mismatch error in immediate window i could not find your mail id. could you please give your mail id , so that i can send my problem in detail.

Thanks!

Hi Dinesh sir, thank you for such knowledge providing videos..it helps us a lot..... I have quiry if you can help in that.... I have multiple client name wise subfolder in a main folder 2022.and every subfolder has one QC tracker sheet with it client name.... I have to enter the cases on daily basis in these trackers. But not in all trackers..for example...if we received QC data for our 10 clients in a day then we will go those specific clients subfolder and sheet and then enter the the data.... could you please make a video on this topic...how to open specific sheets in through Loop in subfolder and enter the data....it will be a great help for me.... thank you in advance.!!

Sir thank you for your videos. I have a folder and folder has sub folders and each sub folders have some number of file. All these file are linked to 1 source file which will change every month. Can you guide how using macro we can change link of all these files in subfolder to the new source file Your guidance will be of great help!!! Thank you!

is this possible in python ? if yes can anyone help me out ??

Sir in this code I have embedded your another vba code for copying data (in a row) from non-adjacent cells into one sheet. My aim is to create a summary of salary details (allowances, deductions, net pay, gross pay etc.) for all employees. For this purpose, I need to enhance the functionality of this code to enter details of each employee in a separate row. Currently it adds data from all excel sheets into a single row. Please guide how to resolve this issue. (1): When pasteRange is used outside this For loop, it creates runtime error 1004. For Each cel In copyRange cel.Copy ecolumn = Sheet1.Cells(4, Columns.Count).End(xlToLeft).Offset(0, 1).Column pasteRange.Cells(4, ecolumn).PasteSpecial xlPasteValues Next And when used inside the loop, it pastes data as mentioned above. (2): I have placed the above For Loop inside Do-While loop in between two lines: set wbk.............................. wbk.close.......................... I have noted that row in pasteRange can be changed by changing the number 4 in the above lines. But getting no idea to go to the next line after the data for one employee has been copied. Please guide as early as possible. Thanks.