Good day guys!
Can you please help me on this?
Here are the parts of my project and its code.
My project is to consolidate data from text file(.txt)
*note that i can select multiple text file, in which 1 text file = 1 sheet
*What is happening is that it is opening a new workbook
*How can I make it open to just the same workbook but just different sheet
Here is my code for that part:
And then delete rows that has blank in selected columns.
*can I make an excemption and choose only 2 columns?
*also note that different text files also has different number of columns.
Here is my code for the deletion part of rows part
Can you pleas help me combine this two codes and make it that after consolidation, rows with blank are already deleted. Thank you
I've already tried different techniques but still to no avail.
New set of codes will be highly appreciated if it is for the best.
Bookmarks