Import Column based on Column Header name

[JulieQ]

Learning as go again....

I have a CSV file with names on the Column Headers (i.e. LastName, City, OS Type). I only want to import certain columns, based on column header name (i.e. LastName, OStype) into a new worksheet, and into a specific column order (which is different from the order they are in the CSV).

I am able to import the CSV file by column (i.e. A/1st), but I want by column header (i.e. LastName). Any suggsetions where to start when using column header name?

Thx,
J.

[MarvinP]

Hi Julie,

I believe you will need to import the entire csv file and then delete the columns you don't want. A VBA macro might be useful here if you have lots of these to do. If you supply a small sample of the csv file and note the column names you want to keep and in what order, we can whip up some code to do what you want.

[JulieQ]

I provided an example using a different CSV file; "export" worksheet would be the source data. The result is, I only want column "Area", "Status", "Start", "End" imported into the new destination worksheet.

The actual export file could have 10-22 columns and 300-900 rows of data.

Note: The 'export' file, the columns will not be in an consistent order each time the data is exported from the source application (this is due the export is being performed by different teams / different source setup). Example: "Area" might be column C on Monday's export, and in column A on Friday's export.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.