I have to import data from a .csv file every week. The data is based on a report so throughout the data there is Header information due to the page breaks of the report. Does Excel have any feature that would allow me to create a Mask (or template) that recognizes the layout of the report and only imports the actual data and not the Header information.
In the past, I had access to a software program called DataImport that you could create a mask for and when you imported the .csv file into it. The mask was designed to exclude the header info, so all I imported into Excel was the data.
Wanted to see if Excel has any way to do something similar??
Thanks.
In the past, I had access to a software program called DataImport that you could create a mask for and when you imported the .csv file into it. The mask was designed to exclude the header info, so all I imported into Excel was the data.
Wanted to see if Excel has any way to do something similar??
Thanks.