Видео

You can remove loops from sheets

Noted

You can email us for excel file

Please email us levelupexcelskill@gmail.com

@@levelupexcelskill ok

Thanks for your feedback ☺️

Please share the email address

Plz share thi file for prectice

@@Rj-tr4uj sent

Could you please email us?

Thank you 🙏

You can change the source code

Bro??

konse position ke liye bro

Q ki mera bhi ho skta resume shorlist or uske baad assesment test

Please find the below code for your reference Sub ConsolidateFiles() Dim folderPath As String Dim targetWorkbook As Workbook Dim ws As Worksheet Dim fileName As String Dim sourceWorkbook As Workbook Dim sourceSheet As Worksheet Dim lastRow As Long Dim headerColumnIndex As Variant ' Set the target workbook (where you want to consolidate the data) Set targetWorkbook = Workbooks.Add ' Specify the folder path containing the Excel files to consolidate folderPath = "C:\Path\To\Your\Folder\" ' Loop through each file in the folder fileName = Dir(folderPath & "*.xlsx") Do While fileName <> "" ' Open the source workbook Set sourceWorkbook = Workbooks.Open(folderPath & fileName) ' Loop through each sheet in the source workbook For Each sourceSheet In sourceWorkbook.Sheets ' Find the column index of the specified header headerColumnIndex = Application.Match("YourColumnHeader", sourceSheet.Rows(1), 0) ' Check if the header exists (headerColumnIndex is not an error) If Not IsError(headerColumnIndex) Then ' Find the last row in the target sheet Set ws = targetWorkbook.Sheets.Add lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row + 1 ' Copy data from the source sheet to the target sheet sourceSheet.UsedRange.Copy ws.Cells(lastRow, 1) End If Next sourceSheet ' Close the source workbook without saving changes sourceWorkbook.Close False ' Get the next file in the folder fileName = Dir Loop End Sub

Just do it manually first then apply in your coding....if you need further help please share a file with me on levelupexcelskill@gmail.com

You can use loops for column

Haanji aap mujhe levelupexcelskill@gmail.com per mail kr do

ruclips.net/p/PLZYYKHUNYEk1rqTDUjJ9aLes4eL7S0B-p&si=g4ebpaf3pAYALJDr

You can email if you need any help levelupexcelskill@gmail.com

Please share your email id

You can simply add code wb.name below the loop

You can customize as per your requirement

Thank you. Aap mujhe email kr sakte hai levelupexcelskill@gmail.com

Yes, please share the same file with us on our email id levelupexcelskill@gmail.com

@@levelupexcelskill i have shared the file over an above mail

@@abhishekawari919 shared please check