Import Delimited File

[Guest]

Is there a way import a delimited file into excel to go to multiple
worksheets? We would like to break up the data in a file by sales group to
be on different sheets?

 

[Guest]

Can be done, but only way I know how would be with VB to process the file
during input instead of using the default delimited file importer.

Think about going ahead and getting the data into a single sheet then use
Data | Filter | AutoFilter
to identify the various groups. While you have a group in view (with others
hidden) you can copy those rows to other sheets and even delete (just) those
rows, then choose a different group, repeat as required.

If you've got an incredibly large number of sales groups to deal with and/or
this is going to be a frequently performed operation, you may want to
consider recording a macro as you do it and then modifying the macro to add
new data imported to the bottom of existing data for each sales group. Or
just write a macro that does all of the data movement for you.