Compare Headers in 2 different spreadsheets

r055c

New Member
Joined
Feb 24, 2009
Messages
30
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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Marc L

Well-known Member
Joined
Apr 5, 2021
Messages
1,238
Office Version
  1. 2010
Platform
  1. Windows
Hi,​
whatever by formula or VBA you can use the MATCH worksheet function for example …​
 

Forum statistics

Threads
1,141,072
Messages
5,704,133
Members
421,329
Latest member
mippy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top