Excel Import Specific Columns

[muppet99]

Hi

I've got a delimited text file that I want to import, however I want specific columns ie, cols 1,7,8,9.
I've imported the data to a workbook, now I want to strip out the columns in question and copy them to my final sheet.
I've set up a mapping column on a datasheet , so in future if the columns change it's configurable.
Any help would be greatly appreciated.

Muppet

 

[SkipVought]

Hi,

Either use MS Query to return ONLY the columns you want (assuming your text file has a row of headings, or import into Excel and THEN use MS Query to return what you need to another sheet. Virtually no VBA required!

faq68-5829

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}