Hi,
Hoping somebody can help.
I'm looking after reporting in my company for a short period and there are a number of manual tasks that the normal person does which i'm sure can be somewhat automated within excel to speed things up however i'm not too sure how to do it.
The Scenario
We have a number of reports setup that displays data in a specific way (with bar charts, line graphs etc.....) this reads the data from a 'source file'; which is just an exported csv file
The Problem
The issue that we have is when people update go to produce a new source file they generally don't pay too much attention to what columns they are exporting along with the name of the file.....essentially for the report to work, the file name, column headers need to be exactly the same.
At the moment i/we are going through the new files and looking at the column headers, making sure they are the same and removing columns that don't need to be there.
Hopeful Solution
Is there someway, either by formula, vba or macro that will look at the new file, compare it to the original file and highlight what the differences are (i.e. missing columns, columns not in the right order, additional columns not in the original file)
Fully appreciate that i may not be able to have this fully automated but anything will be better than now
Hoping somebody can help.
I'm looking after reporting in my company for a short period and there are a number of manual tasks that the normal person does which i'm sure can be somewhat automated within excel to speed things up however i'm not too sure how to do it.
The Scenario
We have a number of reports setup that displays data in a specific way (with bar charts, line graphs etc.....) this reads the data from a 'source file'; which is just an exported csv file
The Problem
The issue that we have is when people update go to produce a new source file they generally don't pay too much attention to what columns they are exporting along with the name of the file.....essentially for the report to work, the file name, column headers need to be exactly the same.
At the moment i/we are going through the new files and looking at the column headers, making sure they are the same and removing columns that don't need to be there.
Hopeful Solution
Is there someway, either by formula, vba or macro that will look at the new file, compare it to the original file and highlight what the differences are (i.e. missing columns, columns not in the right order, additional columns not in the original file)
Fully appreciate that i may not be able to have this fully automated but anything will be better than now