School directory using consolidation and deletion of rows

Good day guys!

I would like to have some help on my mini template project. I am having a hard time with VBA codes.

Here's how my project will need to work. I need to transfer text files(.txt) to the same workbook, but 1 worksheet for each text file. In here, I can choose multiple files. After that, I need to delete WHOLE rows that has a blank cell(except 1st column), starting from row 4. Then the last requirement would be to fill the 1st column, a portion of the text file's name.


Here,

First, I need to click the command button in order to choose the files I want to load.
first.png


And then, if I chose two .txt files. It will also load two text files. In here it is, CLASS 2014 and CLASS 2013
second.png


What I want to happen next is for "2014" to be inputted in columns 1, rows 5 to 15. And then delete rows with blank cell, in which here is rows 8, 10, 11, 12 and 15.

Thank you and I hope you can help me and my alma mater. Thank you!

Bump, help please

Help guys, really need this I still cant figure it out after whole day studying and watching tutorials.

Originally Posted by sinan.plater

Load your project my friend. May be I can assist you ...

Thank you so much @sinan.plater!

This what I cuurently have sir.

here is my code in the consolidation, but i cant make it appear on the same WORKBOOK. What happens is that it opens a new excel file.

Please Login or Register  to view this content.

While here is my code for the deletion of rows with blank cells.

Please Login or Register  to view this content.

What I want to happen is to combine both with just one click and then add to the first column a part of the filename. Make it happen in one workbook hehe

Regards,

Watiwawa

Originally Posted by sinan.plater

Watiwawa please use filedropper.com and load your file. OK !

Sir, do I have any other choice where I can upload the file? The site is currently blocked here in our office. I can send it to your email.

Originally Posted by sinan.plater

[email protected]

Mail sent, thank you so much

Bump, not yet solved