Hello!

I am in way over my head with a task I've been given and I'm hoping someone can help me out! I am completely new to VBA, so any and all tips are much appreciated.

I have an existing template that I need to add a table to. I've created the header and one blank row to start, and what I'd like to do now is create a module that allows the user to select the file path for a text file, auto-generate the number of rows required, then populate the table with the contents of the selected file.

The data in the text file is separated by tabs, but I also need to leave one blank cell at the end of each row (ie the table has a column that shouldn't be populated with any data).

Does this sound like a plausible task? I'm happy to provide more context if needed! I've been scouring this forum in hopes of finding a good place to start but I'm still at a loss. I'd be grateful for any advice on how to proceed!

Thank you