Delete First & Last Line of Imported Data

[vxs]

Hi All,
I am importing some data from a .txt file but the import data's first and last lines are un-important headers and totals which get in the way of how I am using the data.

Other than having to manually delete them on each refresh what is the easiest way of automatically deleting them on import please?

Any help much appreciated. Spent some time googling and only found VB scripts which seems a bit extreme, thought their would be an option to unselect the top line or more...

Thanks

 

[Roderick_E]

Is there a "trigger" I can use that remains the same in this first row and last row? For example will the first cell of the header be A1? or at least in column A? And same for last row. Does it always say Total or something and is it always in the same column?

If so, I can give you an easy copy paste VBA that will check for these triggers and if they exist, it will delete either the content of the rows or the entire rows as you'd like.

 

[vxs]

Im afraid there isn't a trigger which is why I am struggling to find a useful solution when googling.

The First Line is TEXT which changes and the Last Line is a total in NUMBERS which changes. There is No Word TOTAL next to the last number in the last row.

I just thought there might be a script or option to Strip the first and last rows? Also the import data changes constantly so the amount of rows changes constantly, so I can't even say DELETE ROW 1 and DELETE ROW 100 because 100 might be 400.

Thank you for respodning and trying to help Roderick_E