PDA

View Full Version : Excel VBA to import txt file AND automatically insert rows



Techgirl7
10-10-2017, 12:14 PM
I have a form that I need to populate with a text file. I need to be able to import this, but the form only has room for 10-15 rows of new data. There is info above and below that area I will be importing to. So if I have 20 rows in the text file, it will need to read the text file, count the rows, (20), then go to Cell A25, make sure there are 20 blank rows, then import the data.

Is this possible?
Techgirl7

mdmackillop
10-16-2017, 05:36 AM
Is your data in one column or multiple?