Hello
I have multiple sheets for each file
all of files are existed in this directory "C:\Users\AMMR\Desktop\VB"
in master file will contain multiple sheets and each sheet will contain headers from row1 and column A , also each sheet contains data and headers start from row 1 and from column A for the others files .
so should match headers for each sheet in master file with all of sheets in all of files and populate data based on headers from all of files .
every time run the macro should clear data for all of sheet in master file before brings data.
thanks
I have multiple sheets for each file
all of files are existed in this directory "C:\Users\AMMR\Desktop\VB"
in master file will contain multiple sheets and each sheet will contain headers from row1 and column A , also each sheet contains data and headers start from row 1 and from column A for the others files .
so should match headers for each sheet in master file with all of sheets in all of files and populate data based on headers from all of files .
every time run the macro should clear data for all of sheet in master file before brings data.
thanks
